Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    46

    Unanswered: Export and Import command in Oracle10g

    Hi,

    I want to Export and Import the Oracle10g Database.for that i am using below command:

    Export--> exp scot/tiger full=y file=d:/testdb.dmp grants=y

    Inport--> imp scot/tiger full=y constraints=y ignore=y

    But when i m running Export command in command prompt it is giving me error message as follows :


    EXP-00056: ORACLE error 6550 encountered
    ORA-06550: line 1, column 41:
    PLS-00302: component 'SET_NO_OUTLINES' must be declared
    ORA-06550: line 1, column 15:
    PL/SQL: Statement ignored
    EXP-00000: Export terminated unsuccessfully


    while the same command are working in Oracle9i

    Please suggest!

    Thanks,
    Prasad

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Which of the 494 possible solutions that Google throws up have you tried?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •