Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

transport tablespace problem

401344Feb 13 2004 — edited Feb 16 2004
i have use transport tablespace feature in export for exporting one particuler tablespace(exp_t).
i have create table in exp_t tablespace by user sys
i have create like
create table a(
no number)
tablesapace exp_t;

and after it i set tablespace in read only mode
at the time of export
i got error
ORA-29341: The transportable set is not self-contained

for checking i have use
EXEC DBMS_TTS.TRANSPORT_SET_CHECK('EXP_T',TRUE);

SQL> select * from sys.transport_set_violations;

VIOLATIONS
----------------------------------------------------------------------------
Sys owned object A in tablespace EXP_T not allowed in pluggable set

what it means??????????
i have create table by user sys BUT i have specify tablespace exp_t with table
then what's the problem
after droping this table every thing is ok no error

again try this procedure with other user scott whoes default tablespace is system
again i issue
create table a(
no number)
tablesapace exp_t;

but this time no error occurs
same situation in both time
but why error occur when i create table with sys

kuljeet pal singh


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2004
Added on Feb 13 2004
5 comments
286 views