importing data script question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: importing data script question

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    importing data script question

    import documentation script

    Unzip the export file



    Disable constraints before importing the data

    drop the indexes

    truncate the table

    Create a script file (create_nmtabledata.sql) using the information below


    imp userid=system/manager fromuser=scott tables=(emp,dept)
    file=exp_scott.dmp log=imp_scott.log indexes=n ignore=y b

    recreate the indexes

    reenable the constraints
    my question is when will you include buffer=64000 and commit=y

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    imp help=y
    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
    Jan 2001
    Posts
    3,131
    I would create a parfile not a sql file.


    file=exp_scott.dmp
    log=imp_scott.log
    userid=system (Never put a password in a parfile!!)
    fromuser=scott
    touser=?????
    tables=(emp,dept)
    indexes=n
    ignore=y
    Buffer=4000000
    commit=y

    The buffer and commit are only used for large tables, if you are dealing with small tables you don't really need it.


    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100
    Originally posted by Mr.Hanky
    I would create a parfile not a sql file.


    file=exp_scott.dmp
    log=imp_scott.log
    userid=system (Never put a password in a parfile!!)
    fromuser=scott
    touser=?????
    tables=(emp,dept)
    indexes=n
    ignore=y
    Buffer=4000000
    commit=y

    The buffer and commit are only used for large tables, if you are dealing with small tables you don't really need it.


    MH
    if you dont remove the indexes and recreate them after the import what would happen to the data when trying to insert to an indexed table aside from the import going slowly?

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