1. I want to alter user a and set default tablespace as b_data.
( This can be done just by alter user .... deafult tablespace...)
2. i have to drop the tablespace a_data along with physically removing the file, before doing this i want to move all the tables and data relating to user a(tablespace a_data) to tablespace b_data.
i dont want to use export and import. Can this be done without taking logical backup and importing the same. Please help me out in this matter and i will be very greatful to you all. I am using Oracle 8.0.5 on NT.
07-10-2001, 05:13 AM
you can do :
alter table [table] move tablespace [new tablespace]