Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

script for Drop the list of give schema and Import the data for that list of schema.

Posted on 2012-03-30
5
Medium Priority
?
439 Views
Last Modified: 2012-06-21
please provide me with the shell script to drop the schema and import the data from that  list of schema
Assume the dmp file was copied form production already
0
Comment
Question by:ajaybelde
  • 3
  • 2
5 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37789729
I'm afraid you didn't provide anywhere near enough information.

First: classic impexp or the new datapump expdp/impdp?

A lot also depends if the export was a FULL or not.  Some imports do not re-create the schemas.  If you drop them you would need to re-create them before import.

What exactly are you wanting to do?
What type of export was performed?
What type of import do you want to do?
etc...
0
 

Expert Comment

by:edreamers
ID: 37819884
drop user <user name> cascade

create user <user name> identified by <user name>

grant dba to <user name>

then type
imp
in command prompt
give user name and password

then the path of your database backup

thats it.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37823118
>>grant dba to <user name>

I would not suggest this.  DBA is a very powerful role and should only be granted to users that need it.
0
 

Expert Comment

by:edreamers
ID: 37824843
you will need special role for importing data. normal user with limited access will not do this.
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 37824856
Yes, but not DBA.

This also assumes the user itself is doing the importing.  In this situation, I would import as a priviledged user and NOT give the user in question any 'special' roles.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) 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 explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

578 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