materialized view import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: materialized view import

  1. #1
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195

    materialized view import

    I could not import materialized view from one scema to another. Any work arounds? Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: materialized view import

    Originally posted by dba1
    I could not import materialized view from one scema to another. Any work arounds? Thanks.
    describe the steps you took and the errors you received
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    Schema A is set to have replication feature.
    Steps:
    1) I export db from schema A.
    2) I import it to schema B.
    Here is the error message below. Obviously, 'imp.exe' does not replace schema name 'A' with 'B'.

    IMP-00015: following statement failed because the object already exists:
    "CREATE SNAPSHOT LOG ON "A"."FORECAST" WITH PRIMARY KEY EXCLUDIN"
    "G NEW VALUES USING ("MLOG$_FORECAST", ........

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    full import statement please

  5. #5
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    We have found the explanation from Oracle's doc. Here it is:

    Importing a Snapshot into a Different Schema
    Snapshots, snapshot logs, and related items are exported with the schema name explicitly given in the DDL statements; therefore, snapshots and their related items cannot be imported into a different schema.

    If you attempt to use FROMUSER and TOUSER to import snapshot data, an error will be written to the Import log file and the items will not be imported.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    time to change the import file then with the correct user

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