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

Thread: Import/export

  1. #1
    Join Date
    Oct 2000

    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
    Portsmouth, NH, USA

    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
    San Francisco, California
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.