• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

want to import schema

Hi guys,
I want to refresh  multiple schemas with datapump, whats the best way I should drop the existing schemas, objects or I can use any parameter in the import script.
If I need to drop how can I drop schemas or objects with the help of shell script.
0
nirvairghuman
Asked:
nirvairghuman
2 Solutions
 
OP_ZaharinCommented:
- you can use EXPDP with CONTENT=METADATA_ONLY option for getting only database object definitions. no data is included see further in the link:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#sthref90

- then use IMPDP to import the dumpfile

- to drop schema, you can issue DROP USER schemaname. this will drop the user and its objects. i would suggest that you do a full backup first, then create the metadata_only dumpfile and lastly drop the schema.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9008.htm
0
 
Swadhin RaySenior Technical Engineer Commented:
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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