OraFAQ Forum: Server Utilities » Export, Import only Procedures and Packages

Home » RDBMS Server » Server Utilities » Export, Import only Procedures and Packages

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

Export, Import only Procedures and Packages [message #221976]

Thu, 01 March 2007 06:28

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

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #221981 is a reply to message #221976]

Thu, 01 March 2007 06:51

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #221982 is a reply to message #221976]

Thu, 01 March 2007 06:54

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

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #221985 is a reply to message #221982]

Thu, 01 March 2007 07:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

OP asked
>>using Export and Import Utility.

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #221987 is a reply to message #221982]

Thu, 01 March 2007 07:03

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

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #222014 is a reply to message #221985]

Thu, 01 March 2007 08:10

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

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #222018 is a reply to message #222014]

Thu, 01 March 2007 08:26

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Try using a parfile instead

USERID=development/dev
FILE=emp.dmp
tables=(emp,
dept)

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #222026 is a reply to message #222018]

Thu, 01 March 2007 08:38

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Thanks,
It worked. Do you think it is something OS specific?

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #222045 is a reply to message #222026]

Thu, 01 March 2007 09:15

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #222049 is a reply to message #222045]

Thu, 01 March 2007 09:27

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Using AIX 5.3

Report message to a moderator

Re: Export, Import only Procedures and Packages [message #222183 is a reply to message #222049]

Fri, 02 March 2007 03:52

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,

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:45:42 CDT 2024