archiving tablespace on Oracle 8.1.7
I need to archive a tablespace on Oracle 8.1.7 on Win2k. Its like this - I have a user and 3 tablespaces attached to this user userName, userNameIndex, userNameReport. I no longer need this schema(user) and its objects, So whats the best way to fully remove this schema (3 tablespaces) from the database to make some space on the server and still be abe to recover it back into database if need be in future.
Do you think
Export/Import with Transport_Tablespace=y is all what I need. What are the dependencies/prerequisites I need to be careful about.
-D
export tablespace error on win2k/oracle 8.1.7
While trying to do the export I am getting errors:
==================================================
(exp 'sys/syspassword@db as sysdba' TRANSPORT_TABLESPACE=y TABLESPACES=(ALSO, ALSO$I) ROWS=y FILE=c:\also_exp.dmp LOG=c:\also_exp.log)
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
Note: table data (rows) 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 1031
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
I have executed
dbms_tts.transport_set_check('ALSO,ALSO$I', TRUE);
which does bring me an empty TRANSPORT_SET_VIOLATIONS view.
telling me that set of tablespaces is self-contained
Also why it say its now going to export ROWS data
-D