Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Unanswered: Importing a dump file into a different tablespace

    Hi,

    Here is my problem. I have a schema 'msdb1'. The default tablespace for the user is msdb1. I have exported from the schema, and want to import the dump file into a new user 'msdb2', which has a default tablespace msdb2. But when I have run the import, the tablespace for all of the tables in the new msdb2 schema is still msdb1. How can I export/import so the tables in the msdb2 schema use the msdb2 tablespace? Nothing I have tried has worked. I am importing and exporting using command line.

    Cheers,

    Ian

  2. #2
    Join Date
    Jul 2002
    Posts
    1
    Hi Ian,

    revoke unlimited tablespace from user msdb2
    and grant unlimited quotas on tablespace msdb2 to user msdb2.

    REVOKE UNLIMITED TABLESPACE FROM msdb2
    ALTER USER msdb2 QUOTA UNLIMITED ON msdb2

    Now you can Import an the import use tablespace msdb2.

    Heino.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •