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.
Click Here to Expand Forum to Full Width