DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Problems when importing on NT

  1. #11
    Join Date
    Mar 2001
    Posts
    9
    Check whether you have sufficient space to create the files

    regards
    uma

  2. #12
    Join Date
    Nov 2000
    Posts
    42

    Thumbs down Another problem

    Hi guys, I've got another problem.

    After doing 'imp80 parfile=mypar.par 2>mylog.log' (including 'ignore=y'), I got this warning, and my NT tables are EMPTY:

    ----//---------
    Export file created by EXPORT:V08.00.04 via conventional path
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('SID.WORLD','HP900"
    "0/800-7.0-8.0.0'); END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 1, column 40:
    PLS-00302: component 'QUEUE_IMPORT_CHECK' must be declared
    ORA-06550: line 1, column 9:
    PL/SQL: Statement ignored
    . . importing table "DEF$_AQCALL" 0 rows imported

    ...

    ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
    . . importing table "REP$_AUD_COLUMN" 0 rows imported
    . . importing table "REP$_COL_GROUP" 0 rows imported

    ...

    About to enable constraints...
    Import terminated successfully with warnings.
    ----------------------//-------------------

    Any suggestion?
    ========
    LARRY ELLISON

  3. #13
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You need to run the $ORACLE_HOME/rdbms/admin/catrep.sql
    to create the necessary replication objects. Then run the import.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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