| full export in HP unix using sys as sysdba [message #243807] |
Sat, 09 June 2007 03:02  |
hishamshahbaz
Messages: 3
Registered: June 2007
|
Junior Member |
|
|
hi,
I am trying to take an export of the full database using sys as sysdba. the script is given below:
-------------------------------------
pre='/myFolder/my_exp'
timestamp=`date '+%d%m%y'`
logfile='_log.log'
dumpfile='_dump.dmp'
file_name=$pre.$timestamp.$dumpfile
log_file=$pre.$timestamp.$logfile
exp sys as sysdba/ file=$file_name log=$log_file FULL=Y ROWS=Y
-------------------------------------
it gives the following error:
LRM-00108: invalid positional parameter value 'as'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
oracle version is 9i and os is hp unix...
|
|
|
|
| Re: full export in HP unix using sys as sysdba [message #243811 is a reply to message #243807] |
Sat, 09 June 2007 03:34  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ Don't use sys to export unless you use special features like FGAC. Use a DBA account.
2/ If you still want to use sys enclose it between quotes: 'sys as sysdba'
In addition, your variable in parameter "log=" is not the one you set.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
