Home » RDBMS Server » Server Utilities » Query regarding importing DUMP file
Query regarding importing DUMP file [message #215578] Mon, 22 January 2007 23:55 Go to next message
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.
Re: Query regarding importing DUMP file [message #215580 is a reply to message #215578] Tue, 23 January 2007 00:04 Go to previous messageGo to next message
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
Re: Query regarding importing DUMP file [message #215583 is a reply to message #215580] Tue, 23 January 2007 00:15 Go to previous messageGo to next message
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 ..
Re: Query regarding importing DUMP file [message #215586 is a reply to message #215583] Tue, 23 January 2007 00:22 Go to previous messageGo to next message
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
Re: Query regarding importing DUMP file [message #215588 is a reply to message #215586] Tue, 23 January 2007 00:25 Go to previous messageGo to next message
kanis
Messages: 61
Registered: November 2006
Member
So for oracle 9i what will be sol~n for the problem.
Re: Query regarding importing DUMP file [message #215591 is a reply to message #215588] Tue, 23 January 2007 00:37 Go to previous messageGo to next message
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
Re: Query regarding importing DUMP file [message #215600 is a reply to message #215591] Tue, 23 January 2007 02:06 Go to previous message
Littlefoot
Messages: 20888
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.
Previous Topic: need to extract DDL script
Next Topic: Loading data using external table .
Goto Forum:
  


Current Time: Sat Dec 03 12:26:02 CST 2016

Total time taken to generate the page: 0.06269 seconds