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!

how to transport self contained tablespaces???

AlokKumarNov 19 2004 — edited Nov 19 2004
I want to know that how to know that the table is
self containted,although I Check through DBMS_TTS
Package .

I tried this

begin
SYS.DBMS_TTS.TRANSPORT_SET_CHECK
('ALOK','ALOK1') ;
END ;
/

and got these errors

ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to
'TRANSPORT_SET_CHECK'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

why I got thede errors??

and one more question that i have got 2 t'space in my database
are alok and alok1 and alok has few tables in it and alok1 contains
nothing,although alok t'space has all the dependent segments inside
the t'space,but when I exp t'space by using this commands

$ exp transport_tablespace=(ALOK,ALOK1) constraints=n indexes=n

I got the errors that the t'space is not self contained..

plese advise me....
thanks a lot in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2004
Added on Nov 19 2004
1 comment
212 views