Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

full import versus schema imports

Status
Not open for further replies.
TheDash

TheDash

MIS
Mar 25, 2004
171
US
Hello members,
What is the difference between creating an Oracle 10 database and export importing all schemas from another db into it versus a full import? We are concerned about losing privileges on sys objects etc when a schema level import is done. What are the prerequisites before doing a full import? Thank you.
 
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question
History log of all SQLs of a particular schema
Replies
2
Views
134
rk68
rk68
rk68
  • Locked
  • Question
data import using SQLLDR
Replies
5
Views
110
rk68
rk68
AlStl
  • Locked
  • Question
Accessing Objects in another schema under same database 1
Replies
4
Views
105
Beilstwh
Beilstwh
garani
  • Locked
  • Question
Oracle 12c Versus Oracle 11G
Replies
1
Views
69
johnherman
johnherman
rk68
  • Locked
  • Question
giving user rights to access another schema
Replies
2
Views
88
LKBrwnDBA
LKBrwnDBA

Part and Inventory Search

Sponsor

Back
Top