Home » RDBMS Server » Server Utilities » how to execute the CATPROC.SQL
how to execute the CATPROC.SQL [message #614949] Thu, 29 May 2014 01:29 Go to next message
mist598
Messages: 1029
Registered: February 2013
Location: Hyderabad
Senior Member
Hi,

I needed to execute the CATPROC.SQL
SQL >@ $ORACLE_HOME/rdbms/admin/CATPROC.SQL


Thanks
Re: how to execute the CATPROC.SQL [message #614950 is a reply to message #614949] Thu, 29 May 2014 01:41 Go to previous messageGo to next message
Littlefoot
Messages: 19815
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How to do it? The same way you run any other SQL script.
Re: how to execute the CATPROC.SQL [message #614951 is a reply to message #614950] Thu, 29 May 2014 01:44 Go to previous messageGo to next message
mist598
Messages: 1029
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Littlefoot,

We are getting the below error's while update my database with data from a dmp file.
I have to update my database with data from a dmp file, but when performing import the following error message appears:
UDI - 31626: OPERATION GENERATEX ORALCE ERROR 361626
ORA - 31626: job does not exist
ORA - 06512: AT "SYS.DBMS_SYS_ERROR", line 79
ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 1137
ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 3414
ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 4593
ORA - 06512: AT line 1


Thanks
Re: how to execute the CATPROC.SQL [message #614952 is a reply to message #614951] Thu, 29 May 2014 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 59803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can ignore that and manually recreate the jobs as per your needs.

Re: how to execute the CATPROC.SQL [message #614953 is a reply to message #614951] Thu, 29 May 2014 01:54 Go to previous messageGo to next message
Littlefoot
Messages: 19815
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORALCE?!?
Quote:

UDI - 31626: OPERATION GENERATEX ORALCE ERROR 361626

Are you sure that this is exact copy/paste?

What does your last message have to do with the original question? You asked "how to execute catproc.sql". So, did you finally do it or not?
Re: how to execute the CATPROC.SQL [message #614954 is a reply to message #614952] Thu, 29 May 2014 01:54 Go to previous messageGo to next message
mist598
Messages: 1029
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
You can ignore that and manually recreate the jobs as per your needs.

Hi sir, i am new of this topics and could you please what are steps to required?

Thanks
Re: how to execute the CATPROC.SQL [message #614955 is a reply to message #614952] Thu, 29 May 2014 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also what is the relation with this and the title?
And why is it in Unix forum?

Re: how to execute the CATPROC.SQL [message #614956 is a reply to message #614953] Thu, 29 May 2014 01:57 Go to previous messageGo to next message
mist598
Messages: 1029
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Are you sure that this is exact copy/paste?

not copy/paste ...just written
Quote:
What does your last message have to do with the original question? You asked "how to execute catproc.sql". So, did you finally do it or not?


No,not did..
Re: how to execute the CATPROC.SQL [message #614957 is a reply to message #614954] Thu, 29 May 2014 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you need the jobs?

Re: how to execute the CATPROC.SQL [message #614958 is a reply to message #614954] Thu, 29 May 2014 02:02 Go to previous message
John Watson
Messages: 4806
Registered: January 2010
Location: Global Village
Senior Member
This topic is confused, because it is only half the story. I'll try to explain.
The story began here,
https://community.oracle.com/thread/3565459
It would seem that the problem is that a Data Pump job was not tidied up properly after completion. One way (a rather drastic way) to fix this is supposed to be running catproc.sql. mist598 tried to do that, but failed because he spelt CATPROC in upper case, which is the beginning of this topic.

I do not know of catproc will fix the issue, but it must be worth trying. So, mist598, you need to connect AS SYSDBA, and then
@$ORACLE_HOME/rdbms/admin/catproc




Previous Topic: SQLLDR Issue with NUMBER data type
Next Topic: ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM
Goto Forum:
  


Current Time: Thu Nov 27 03:42:20 CST 2014

Total time taken to generate the page: 0.08195 seconds