-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|