Home » RDBMS Server » Server Utilities » Export, Import only Procedures and Packages
Export, Import only Procedures and Packages [message #221976] Thu, 01 March 2007 06:28 Go to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi,
Is it possible to export/import ONLY procedures and packages using Export and Import Utility.

Thanks
qA
Re: Export, Import only Procedures and Packages [message #221981 is a reply to message #221976] Thu, 01 March 2007 06:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not directly.
You will have to say rows=n ( no data exported).
during import use show=y log=somelog.sql (dummy import. Contents are dumped into somelog.sql)
Search the board. Numerous examples.
Much better to use DBMS_METADATA
Re: Export, Import only Procedures and Packages [message #221982 is a reply to message #221976] Thu, 01 March 2007 06:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
INCLUDE
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#i1007837

EXCLUDE
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#i1007829



regards
Taj
Re: Export, Import only Procedures and Packages [message #221985 is a reply to message #221982] Thu, 01 March 2007 07:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
OP asked
>>using Export and Import Utility.
Re: Export, Import only Procedures and Packages [message #221987 is a reply to message #221982] Thu, 01 March 2007 07:03 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Thanks to Mahesh and Mohammad.
I am using Oracle 9.2.0.6 so may not be able to use the Data Pump features.

Regards,
qA
Re: Export, Import only Procedures and Packages [message #222014 is a reply to message #221985] Thu, 01 March 2007 08:10 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Mahesh,
When I use exp to export some tables, it gives the below error. I checked the syntax everything appears to be fine.

$exp development/dev file=emp.dmp tables=(emp,dept)
ksh: 0403-057 Syntax error: `(' is not expected.

I am able to specify a single table and it works.

Can you help me in identifying the problem?

Thanks
qA
Re: Export, Import only Procedures and Packages [message #222018 is a reply to message #222014] Thu, 01 March 2007 08:26 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Try using a parfile instead
USERID=development/dev
FILE=emp.dmp
tables=(emp,
dept)
Re: Export, Import only Procedures and Packages [message #222026 is a reply to message #222018] Thu, 01 March 2007 08:38 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Thanks,
It worked. Do you think it is something OS specific?

Re: Export, Import only Procedures and Packages [message #222045 is a reply to message #222026] Thu, 01 March 2007 09:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Do you think it is something OS specific?

Which OS are you using?
Cannot reproduce the case in SunSparc
Re: Export, Import only Procedures and Packages [message #222049 is a reply to message #222045] Thu, 01 March 2007 09:27 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Using AIX 5.3
Re: Export, Import only Procedures and Packages [message #222183 is a reply to message #222049] Fri, 02 March 2007 03:52 Go to previous message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
Hi,

Infact it is "Korn Shell Specific"

if u want to learn basics of "ksh", u can refer to the following link:

http://us.f318.mail.yahoo.com/ym/ShowLetter?MsgId=8493_23126818_5173983_1591_3235_0_43595_9044_3066709977&Idx=17&YY=22822& ;y5beta=yes&y5beta=yes&inc=200&order=down&sort=date&pos=0&view=a&head=b&box=Inbox


Regards,
Previous Topic: EXP-00003: no storage definition found which oracle client version should I use for exporting ....
Next Topic: Database Import Problem
Goto Forum:
  


Current Time: Fri Dec 02 12:32:51 CST 2016

Total time taken to generate the page: 0.12734 seconds