Export/Import - Urgent!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Export/Import - Urgent!

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Export/Import - Urgent!

    Hi Guys,
    I am exporting a dump file which was created using 7.3 to 9i database.
    9i already contains the table structure,index and constraints and my idea is to
    export only the data.
    Parameter used for export are
    "ROWS=y GRANTS=n INDEXES=n COMPRESS=n CONSTRAINTS=n OWNER=acc"
    and parameter used for Import are
    ROWS=y GRANTS=n INDEXES=y IGNORE=y FROMUSER=acc TOUSER=acc COMMIT=y"

    While importing it shows some unique constraints error.

    Could any one verify my parameter details ang give me some proper guidence.

    Regards,

    Sudheer

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    truncate your tables and disable your constraints BEFORE you import...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Hi

    Hi,
    How do i truncate the tables?
    and how do i disable the constraints?
    Pls do help

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    TRUNCATE TABLE your_table_name

    and

    ALTER TABLE your_table_name DISABLE CONSTRAINT your_constraint_name

    Make yourself familiar with http://tahiti.oracle.com
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Jeff, for your reply to sudheer_nm's last two questions, you showed great restraint...you must've been in a very good mood.
    OCP 8i, 9i DBA
    Brisbane Australia

  6. #6
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Hi

    Thanks All

    Sudheer

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