Problems with exporting tablespace [message #74383] |
Wed, 01 December 2004 23:11 |
Naveen
Messages: 75 Registered: June 2001
|
Member |
|
|
C:>exp 'sys/sys as sysdba' tablespaces=users transport_tablespace=y
Export: Release 9.2.0.1.0 - Production on Thu Dec 2 14:33:08 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
I just want to export the users tablespace, i have made it read only, but this is what happens when i try to export it :-
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
Note: constraints on tables will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29341 encountered
ORA-29341: The transportable set is not self-contained
ORA-06512: at "SYS.DBMS_PLUGTS", line 1093
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Can anyone help ??
REGARDS
NAVEEN.M
|
|
|
Re: Problems with exporting tablespace [message #74386 is a reply to message #74383] |
Thu, 02 December 2004 01:43 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
>> ORA-29341: The transportable set is not self-contained
It means that there are some objects in users tablespace whose dependent objects are in some another tablespace. Before exporting use DBMS_TTS.TRANSPORT_SET_CHECK procedure to check whether the tablespace is self-contained or not. Use :
exec DBMS.TRANSPORT_SET_CHECK('USERS',true,true);
If there would be any error so that would get populated in TRANSPORT_SET_VIOLATIONS table. Resolve all the errors and then go for the export.
Best of Luck
Daljit Singh.
|
|
|
|