Home » RDBMS Server » Backup & Recovery » full export in HP unix using sys as sysdba
full export in HP unix using sys as sysdba [message #243807] Sat, 09 June 2007 03:02 Go to next message
Messages: 3
Registered: June 2007
Junior Member

I am trying to take an export of the full database using sys as sysdba. the script is given below:

timestamp=`date '+%d%m%y'`
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 Go to previous message
Michel Cadot
Messages: 65086
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: Rman error
Next Topic: Restore Database in Prior Time
Goto Forum:

Current Time: Tue Jul 25 04:22:11 CDT 2017

Total time taken to generate the page: 0.07710 seconds