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

Thread: Import/export

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    Red face

    I have two databases "test" and "live" both are structured the same. I want to resize the "test" DB and then import a full export of the "live" into the "test". Are any special parameters required?? nb both the databases have different names and reside on the same NT server.

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up

    as long as you EXPORT=FULL from the 'live' DB and you have created the same tablespaces/datafiles on the 'test' DB then you should be fine to import as sys.

    - Magnus

    ps: i am assuming you know to do tables=Y and rows=Y etc.


    [Edited by jgmagnus on 09-10-2001 at 11:27 AM]

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    You may want to check on ignore=Y parameter.

    For tables, IGNORE=Y causes rows to be imported into existing tables. If a table already exists, IGNORE=N causes an error to be reported, and the table is skipped with no rows inserted. Also, objects dependent on tables, such as indexes, grants, and constraints, will not be created if a table already exists and IGNORE=N.

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