export tablespace error on win2k/oracle 8.1.7 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: export tablespace error on win2k/oracle 8.1.7

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you just need to recover the user, from the FULL/User level export, then yes, you would have to create the user first and then import using the full database dmp file with the option "FROMUSER=... TOUSER=..." This will import the user. IF there is any change on the tablespace name, then the import will fail. IF you have done a full database export then you would be able to see the schema DLL using the show=Y turned on in the import

    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #12
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by daljitsb

    Ok, then how do we make sure that the user being re-created uses the same tablespace what it used for all its objects before I removed it.
    Do I need to run the create user (saved earlier with default tablespace clause) before I run the import user script.

    The question is: Do I need to have the user exist before import or the user will be created automatically with the import user script and objects will be written to which tablespace. I want it to use recreated tablespace.

    Also do you suggest using ignore=y
    and can we do this saving user objects at exp/imp tablespace level.

    -D
    That is why you backed up the tablepsace DDL. If you save that you will be able to re-create those tablespaces prior to re-importing that user.

    Another option is to create the user and assign different tablespaces and then run the import. I would use the dropped tablespaces if you plan on creating and dropping this user on a regular basis. This way you can easily drop the tablespaces after dropping the user. You will not be ble to do that if you create the user and import his objects into a used tablespace.

    MH
    I remember when this place was cool.

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