+ Reply to Thread
Results 1 to 9 of 9
  1. 07-03-2008 05:52 AM #1
    NetCohort
    NetCohort is offline Junior Member
    Join Date
    Jun 2008
    Posts
    17

    Import / Tablespace

    Hello,

    I have again a question conerning import of data. I exported a database with the parameter full=y.
    Is it possible to import the data of only one tablespace from the exported dump-file? And if yes, how I can do it?

    Regards
    Reply With Quote Reply With Quote
  2. 07-03-2008 05:58 AM #2
    gopu_g's Avatar
    gopu_g
    gopu_g is offline Senior Member
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    333
    By using datapump You can use remap_tablespace option to import objects of one tablespace to another tablespace
    Reply With Quote Reply With Quote
  3. 07-03-2008 06:10 AM #3
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,488
    Quote Originally Posted by gopu_g
    By using datapump You can use remap_tablespace option to import objects of one tablespace to another tablespace
    Poster doesn't mention using expdp. It looks like poster did a plain "exp full=y" and wants to import the content of a single tablespace which in such a scenario can't be done.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  4. 07-03-2008 06:14 AM #4
    gopu_g's Avatar
    gopu_g
    gopu_g is offline Senior Member
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    333
    hi PAVB,

    I know that....but i dont know we can do it from a normal exp.
    but i read there is one option like remap_tablespace is in the expdp.So if he wished he can go for that
    Reply With Quote Reply With Quote
  5. 07-03-2008 06:29 AM #5
    NetCohort
    NetCohort is offline Junior Member
    Join Date
    Jun 2008
    Posts
    17
    I think expdp is a feature of Oracle 10g, right? I forgot to say I want to import th content of one tablespace on a Oracle 9.2 instance.

    But it seems not to work according to PAVB statement.
    Reply With Quote Reply With Quote
  6. 07-03-2008 06:32 AM #6
    gopu_g's Avatar
    gopu_g
    gopu_g is offline Senior Member
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    333
    yes in 9i it wont work . Datapump is the feature of 10g
    Reply With Quote Reply With Quote
  7. 07-03-2008 10:11 AM #7
    NetCohort
    NetCohort is offline Junior Member
    Join Date
    Jun 2008
    Posts
    17
    Another question. I have saved the *.dbf files of the tablespace, too. Is it possible to replace the old tablespace with the actual tablespace? Or will an error occured after mounting the instance?

    Regards
    Reply With Quote Reply With Quote
  8. 07-03-2008 10:15 AM #8
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,488
    Don't do it in you "live" database; you are going to kill it.

    The good news is that you can use your saved datafiles by creating a new "cloned" database pointing to them, once you have it up-and-running you can export all objects sitting on your infamous tablespace and then import them into your "live" database.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  9. 07-03-2008 10:17 AM #9
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,397

    Talking The tablespace of your desires

    Quote Originally Posted by NetCohort
    I think expdp is a feature of Oracle 10g, right? I forgot to say I want to import th content of one tablespace on a Oracle 9.2 instance.

    But it seems not to work according to PAVB statement.
    If you know the contents of that tablespace (or get them from the DDL generated with show=y) you could import those particular objects (tables) for the tablespace of your desires.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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