Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

impdp single package!

rangapavanDec 12 2011 — edited Dec 12 2011
hi,

i want to import single package.......

how can i?
This post has been answered by Sunny kichloo on Dec 12 2011
Jump to Answer

Comments

Sunny kichloo
You can use include parameter

http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm#sthref308

Refer to this thread

https://forums.oracle.com/forums/thread.jspa?threadID=2164718
1 person found this helpful
Sunny kichloo
Answer
If your query is resolve you can close this thread
Marked as Answer by rangapavan · Sep 27 2020
rangapavan
thq for ur response....

unable to understand...

lets consider my package name is "pack1"

can u tell syntax to import this pack1.....

plz....if u help me...its highly appreciable.........
Sunny kichloo
Refer to the second link which i have mentioned in my post and this will be syntax

impdp dumpfile=<name> SCHEMAS=test INCLUDE=package:pack1
1 person found this helpful
rangapavan
thq once again...

it will import only dat particular package right?

it wont import any other existin objects of that schema?

its throwin error!

value for include badly formed.......

Edited by: sachinpawan on Dec 12, 2011 8:57 AM
Sunny kichloo
Yes it will import that package only

And what syntax you have used,i am not sure about whether to use

package:pack1

or

package:'pack1'
1 person found this helpful
rangapavan
thq

i used both

package:pack1

package:'pack1'
rangapavan
when i used

impdp ..... include=package:'pack1'...

its throwing error
Sunny kichloo
wat about

package:pack1
1 person found this helpful
rangapavan
i tried

all these ways....

package:'PACK1'
package:'pack1'
package:"PACK1"
package: "LIKE 'PACK1'"
oradba
Don't use include in the command line , put it in a parameter file. Depending on your unknown OS there could be specific issues with quotes and double-quotes,which require possibly escape characters:

http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#i1007761
1 person found this helpful
Sunny kichloo
As suggested above by oradba please implement that
Sunny kichloo
If your issue is resolved close the thread and if it is not let us know the errors
Dean Gagne-Oracle
Just a comment: The include and exclude parameters work differently than the tables, schemas, and tablespace parameters. The tables=, schemas=, and tablespaces= parameters take a list. The include and exclude parameters take an expression. Like others have said, it is best to put this type of expression in a parameter file so you don't have to worry about any special characters that may have to be escaped according to the operating system you are using.

So, to include a single package I would use this:

INCLUDE=PACKAGE:"LIKE 'PKG1%'"

But this will include all packages like PKG1%

If you want only 1, then:

INCLUDE=PACKAGE:"= 'PKG1'"

That is double quote " = single quote ' NAME single quote ' double quote "

Hope this helps.

Dean
1 - 14
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 9 2012
Added on Dec 12 2011
#database-key-features, #export-import-sql-loader-external-tables
14 comments
8,085 views