Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

question about import dump with impdp

Hello,
I try to import a dump of a database 10G data to a database 11G data. No object is compressed yet the volume of objects increases.
How can I import only all objects of a schema without indexes, tables and constraints? because I can not recompile all objects
thank you
0
bibi92
Asked:
bibi92
1 Solution
 
slightwv (䄆 Netminder) Commented:
I don't understand the question.

Without importing the tables how do you expect procedures to compile?

Importing specific types of objects is described in the online docs.  Is this the original exp/imp or the datapump expdp/impdp?

What are you wanting to do?
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
Me too could not understand what is your exact requirement.

If you are interested to import only the procedures/functions without tables then we can even use dbms_metadata package to do it with a script.

refer to this : http://www.dbasupport.com/forums/showthread.php?28135-how-to-export-import-procedures-functions-packages

If you are trying to do it with the exp/imp then you need to have rows=n while importing

refer to this : http://www.dba-oracle.com/t_export_stored_procedures_triggers.htm

Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now