Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Errors during Transportable Tablespace export

Prashant DixitApr 15 2012 — edited Apr 15 2012

Hi,

I'm getting a series of error codes while exporting a transportable tablespace to a defined dump destination.

=============================================================================================
1. [oracle@localhost root]$ exp userid='system/oracle90 as sysdba' transport_tablespaces=y tablespaces=users file='/backup/transtable01.dmp'
LRM-00112: multiple values not allowed for parameter 'userid'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

2. [oracle@localhost backup1]$ exp userid="system/oracle90 as sysdba" file='/backup1/transtable.dmp' tablespaces=users transport_tablespace=y
LRM-00108: invalid positional parameter value 'as'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
=============================================================================================

but it is working good if trying with regular export utility:

[oracle@localhost backup1]$ exp sys/oracle90 as sysdba file=abc.dmp tablespaces=users transport_tablespace=y

Export: Release 10.2.0.1.0 - Production on Sat Apr 14 14:11:56 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

EXP-00056: ORACLE error 28009 encountered
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
For tablespace USERS ...
. exporting cluster definitions
. exporting table definitions
. . exporting table DEPT
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table EMP

Platform Details:
Version: Oracle 10g R2
OS: Red Hat Enterprise Linux 5

I'm struck here - Please suggest.

Thanks
Prashant Dixit

Edited by: Prashant_Dixit on Apr 15, 2012 8:33 PM