[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2190
  • Last Modified:

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 ?
0
junaid_baig1
Asked:
junaid_baig1
  • 4
  • 2
4 Solutions
 
Shaju KumbalathCommented:
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 KumbalathCommented:
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 free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
Shaju KumbalathCommented:
or

imp sys/sys fromuser=(A,B,C) touser=(D,E,F)
0
 
Shaju KumbalathCommented:
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now