transport tablespace problem
401344Feb 13 2004 — edited Feb 16 2004i 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