import with indexfile=xxx problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: import with indexfile=xxx problem

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    import with indexfile=xxx problem

    Try to import fromuser touser with indexfile=xxxx, I was expecting tables with data created but instead of index the sql file xxx.sql contents index script, but tables did not created as well.

    Here is the parfile

    fromuser=scott
    touser=s4
    file=f:\napp_scott.dmp
    log=f:\napp_s4_import.log
    ROWS = Y
    IGNORE = N
    COMMIT= Y
    INDEXFILE=f:\xxx.sql

    and this is output:


    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
    . . skipping table "BONUS"

    . . skipping table "DEPT"

    . . skipping table "EMP"

    . . skipping table "SALGRADE"

    Import terminated successfully without warnings.


    why it skips tables?
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: import with indexfile=xxx problem

    Originally posted by farrokhp
    why it skips tables?
    Because you specified indexfile=.

    http://download-west.oracle.com/docs...ch02.htm#17192
    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 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: import with indexfile=xxx problem

    Originally posted by farrokhp
    I was expecting tables with data created but instead of index the sql file xxx.sql contents index script, but tables did not created as well.
    Nothing gets created inside the database if you specify INDEXFILE parameter in import. The only things that actually gets created is the indexfile outputfile itself (plus eventual logfile).
    ROWS = Y
    IGNORE = N
    COMMIT= Y
    All this parameters are redundan and totaly useless when there is INDEXFILE parameter specified.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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