OraFAQ Forum: Server Utilities » import only source (procs, funcs, etc.)

Home » RDBMS Server » Server Utilities » import only source (procs, funcs, etc.)

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

import only source (procs, funcs, etc.) [message #174292]

Sat, 27 May 2006 05:15

tridentadm
Messages: 142
Registered: March 2006

Senior Member

i would like to import only Source (ie. procedures, packages, functions, etc.) from the export i have taken for a particular schema.

is there any way to do the same ??

Report message to a moderator

Re: import only source (procs, funcs, etc.) [message #174296 is a reply to message #174292]

Sat, 27 May 2006 06:19

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

Senior Member
Account Moderator

No direct method(Unless you use expdp/impdp in 10g)
Insert with rows=n ( no data, just tables) and remove tables manually later.
or
Use show=y logfile=somelogfile.log
This somelogfile.log will contain all ddl you want.

Report message to a moderator

Previous Topic:	?expdp on 10gR2(10.2.0.1)
Next Topic:	Where we need to use DIRECT = TRUE for direct path ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 00:45:46 CDT 2024