Some Import & export Issue !


Hello Experts !
  Wish You All, a very happy, Prosperous/Healthfull/Joyfull/TERRORLESS AND Peaceful New Year !!!

     Below are some problems which i faced today, kindly suggest your views !

1. I got below error while importing some schemas using IMPDP , import never started and thrown this error:

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1606
ORA-01403: no data found

2. Is it possible to import multiple users in a single IMP command with fromuser and touser parameters ? if yes , How ?

3. How can we give unlimited quota on many tablespace to many users in a single run ?
junaid_baig1Asked:
Who is Participating?
 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
SolutionTo resolve the issue, follow the steps below:-  (as per Oracle support)

1.) Set the Error Stack 1403 to know exactly which SQL is failing:-

SQL> alter system set events '1403 trace name errorstack level 3';

rerun the datapump import to reproduce the error then disable the events.

SQL> alter system set events '1403 trace name errorstack off';

2.) Once the trace file reveals the problematic SQL, Check for the existence of
table KUPC$DATAPUMP_QUETAB using DBA_OBJECTS.

3.) If present, run

SQL> Analyze table <table_name> validate structure;

4.) If not present or it errors out in step3, create the queue table using the following as SYSDBA:-

SQL> conn / as sysdba
SQL> @?/rdbms/admin/catdp.sql
 
0
 
junaid_baig1Author Commented:

  Please provide some suggestion to the questions as well !

   Is it possible to import multiple users in a single IMP command with fromuser and touser parameters ? if yes , How ?

3. How can we give unlimited quota on many tablespace to many users in a single run ?
0
 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
2.
It is possible to import multiple from users to multiple tousers
imp sys/sys fromuser=A,B,C touser=D,E,F
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
or

imp sys/sys fromuser=(A,B,C) touser=(D,E,F)
0
 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
3. it is not possible, alter user does not support multiple user at one go.
 
0
 
junaid_baig1Author Commented:

Many Thanks !! Could you Please also tell !

How can we give unlimited quota on many tablespace to many users in a single run ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.