DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001


    dear friends

    please help me in this situation.

    the situation is like this

    1. dba_users

    username | default tablespace

    a | a_data
    b | b_data

    2. tablspace and datafile:

    tablespace_name| datafile

    a_tablespace | d:\data\a_data.dbf
    b_tablespace | d:\data\b_data.dbf

    My requirement :

    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.

  2. #2
    Join Date
    Feb 2001
    Paris, France
    you can do :
    alter table [table] move tablespace [new tablespace]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.