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

Thread: Table level export

  1. 06-02-2006, 09:46 AM #1
    smruti123
    smruti123 is offline Junior Member
    Join Date
    Apr 2006
    Posts
    24

    Table level export

    Hi,
    Is there any way to Import tablelevel Export in different tablespaces.
    like table1 in tablespace 1, table2 in tablespace2.

    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 06-02-2006, 09:53 AM #2
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Set default tablespace to tbs1
    import (only) Table1
    Set default tablespace to tbs2
    import (only) Table2
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
  3. 06-02-2006, 10:32 AM #3
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    -- OR -- pre-create the tables in those tablespaces and import IGNORE=Y
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  4. 06-02-2006, 03:48 PM #4
    smruti123
    smruti123 is offline Junior Member
    Join Date
    Apr 2006
    Posts
    24
    Thanks Thomasps
    Thanks LKBrwn_DBA
    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