OraFAQ Forum: Server Utilities » Query regarding importing DUMP file

Home » RDBMS Server » Server Utilities » Query regarding importing DUMP file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query regarding importing DUMP file [message #215578]

Mon, 22 January 2007 23:55

kanis
Messages: 61
Registered: November 2006

Member

I have taken total database dump(Database Export).
Now I need to import only procedure from the total dump.
How i will do that .pls guide me.

Report message to a moderator

Re: Query regarding importing DUMP file [message #215580 is a reply to message #215578]

Tue, 23 January 2007 00:04

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

CMD>IMPDP SYSTEM/ORACLE@DB DIRECTORY=DATA DUMPFILE=DATA INCLUDE=PROCEDURE

regards
Taj

Report message to a moderator

Re: Query regarding importing DUMP file [message #215583 is a reply to message #215580]

Tue, 23 January 2007 00:15

kanis
Messages: 61
Registered: November 2006

Member

Going one Step ahead.
I am using Oracle9i Ver .Does it support IMPDP command.
If I want to import a particular procedure then what i have to do?
Pls guide me ..

Report message to a moderator

Re: Query regarding importing DUMP file [message #215586 is a reply to message #215583]

Tue, 23 January 2007 00:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
I am using Oracle9i Ver .Does it support IMPDP command.
No, you cann't use " impdp DATAPUMP is oracle 10g features
If I want to import a particular procedure then what i have to do?
I don't think you can export procedure from full export dump file.

regards
Taj

Report message to a moderator

Re: Query regarding importing DUMP file [message #215588 is a reply to message #215586]

Tue, 23 January 2007 00:25

kanis
Messages: 61
Registered: November 2006

Member

So for oracle 9i what will be sol~n for the problem.

Report message to a moderator

Re: Query regarding importing DUMP file [message #215591 is a reply to message #215588]

Tue, 23 January 2007 00:37

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Yes you have solution.
1.imp your dump file "ROWS=N" and extract source code of procedure.

2.imp complete dump file in dummy database and through "DBMS_METDATA.GET_DDL" package. extract procedure source code.

regards
Taj

Report message to a moderator

Re: Query regarding importing DUMP file [message #215600 is a reply to message #215591]

Tue, 23 January 2007 02:06

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Or spool the result of IMP command with SHOW=Y to a file; search for the procedure you are interested in, copy it and paste into SQL*Plus to create it.

Report message to a moderator

Previous Topic:	need to extract DDL script
Next Topic:	Loading data using external table .

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 21:27:53 CDT 2024