DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: transfer of tables

  1. 07-26-2001, 02:13 AM #1
    alagy
    alagy is offline Junior Member
    Join Date
    Jul 2001
    Posts
    40
    Hi

    how do I transfer the all tables from 5 tablespaces to 2 tablespaces.
    Oracle version is 8.1.6.

    I need to do it urgent. Can any one help me?
    Reply With Quote Reply With Quote
  2. 07-26-2001, 02:45 AM #2
    dsuva
    dsuva is offline Member
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    the 5 different tablespaces must be associated with different users. take individual exports of all the tables under the different users.

    associate the 2 particular tablespaces (which is to contain all the tables ) with particular users and then simply import your export dump files.
    once it is sucessfully done, remove the 5 tablespace which you do not wan
    Suvashish
    Reply With Quote Reply With Quote
  3. 07-26-2001, 04:18 AM #3
    alagy
    alagy is offline Junior Member
    Join Date
    Jul 2001
    Posts
    40
    is there any other way? All the five tbs belong to one existing user..!
    Relax DBA
    Reply With Quote Reply With Quote
  4. 07-26-2001, 04:45 AM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter table1 move tablespace tbsp1
    alter table2 move tablespace tbsp2
    alter table3 move tablespace tbsp3..... etc
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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