• 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.
2 Solutions
- you can use EXPDP with CONTENT=METADATA_ONLY option for getting only database object definitions. no data is included see further in the link:

- 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.
Swadhin RaySenior Technical Engineer Commented:

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