Loadpsp utility is used for updating the psp files to database.It creates packages for psp files in database.
Loadpsp utility is located at $ORACLE_HOME/bin
Syntax:
loadpsp [-replace] -user <logon> [<page1> <page2> ...]
where <logon> ::= <username>/<password>[@<connect_string>]
where <logon> ::= <username>/<password>[@<connect_string>]
where
replace: Will replace the files.
user : The database user name and password needs to be provided where the psp files need
to be updated.
page:Name and path of psp file.
Example:
$ORACLE_HOME/bin/loadpsp -replace -user scott/tiger Parmlist.psp
Post a Comment
Post a Comment