import only tables, index, grants, statistics etc from exported schema dump file

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

import only tables, index, grants, statistics etc from exported schema dump file

karthikmca.bhc
Hi Erman

I need to export a schema named "DEMO" from source database 11.2.0.3.

In target db 12.1.0.2 the same schema exists and i do not want to drop this schema and import the whole schema from the exported dump. I want to import only tables,indexes,statistics,grants.

What is the procedure to do this? please advise and share docs relates to this requirement.

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: import only tables, index, grants, statistics etc from exported schema dump file

ErmanArslansOracleBlog
Administrator
impdp has such features already.
You can specify object types during your import..
You can overwrite append or skip the your loaded tables.
Read the documentation.
for the list of commands and syntax:  impdp help=y
See -> INCLUDE , EXCLUDE and TABLE_EXISTS_ACTION parameters.
Reply | Threaded
Open this post in threaded view
|

Re: import only tables, index, grants, statistics etc from exported schema dump file

karthikmca.bhc
Thanks Erman for the information. I will go though it.