| Urgent please ! Full parameter to do a full commandline export in 9i [message #72941] |
Fri, 19 December 2003 09:13  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
I'm having trouble using 'sys as sysdba' as a commandline parameter in 'exp' in Oracle 9i. I tried following the syntax, but it doesn't work. For e.g, I want to do the following in commandline mode. Could you please give me the entire commandline (tested and working) for the following:
$exp
Export: Release 9.2.0.4.0 - Production on Fri Dec 19 11:13:46 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Enter array fetch buffer size: 4096 > 128000
Export file: expdat.dmp > thisexport.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1
Export grants (yes/no): yes > yes
Export table data (yes/no): yes > yes
Compress extents (yes/no): yes > yes
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
:
:
Thanks much
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
