1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how can i export data from a tablespace to another table but just the data

Discussion in 'General' started by TheSlayerIsBack, Nov 16, 2012.

  1. hey guys, i need some help, im running the audit in my database but its filling up to fast and since i cant delete the data recored i need to store it in another place for later use but i have no idea how. i need to extract the data from table 1 and put in table 2 so i can delete all from table 1.
     
  2. Jayalakshmi Subramani

    Jayalakshmi Subramani Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    You can use datapump use table level
    content=data only
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Does that table2 exists or you want to create it now?

    If you want to create new table and want to move the data from one to another we can use like below:

    create table destination_table as select * from source_table;

    By this Destination table will be created with the data in source table.
     
  4. Jayalakshmi Subramani

    Jayalakshmi Subramani Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Of course if the table 2 metadata exisist means
    he use
    insert into table2(select * from table1);

    transfer all data from table1 to table2
    and delete the data from table1;
     
  5. Jayalakshmi Subramani

    Jayalakshmi Subramani Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    If the table2 metadata is already available, he like to extract the data only , it best to use

    insert into table2(select * from table1);

    by
    Mrs.Jayalakshmi Subramani