moving data in datafile to another along with the oracle user Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: moving data in datafile to another along with the oracle user

  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