want to import schema

Posted on 2011-10-21
Last Modified: 2013-01-21
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.
Question by:nirvairghuman
    LVL 23

    Accepted Solution

    - 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.
    LVL 16

    Assisted Solution

    by:Swadhin Ray

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows how to recover a database from a user managed backup
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now