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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

renaming Schema

Status
Not open for further replies.
rishiu

rishiu

Programmer
Feb 26, 2001
22
0
0
US
HOw can I rename the Schema.
I know Import/export is one of the option.
Is there any Way. I m using 8.1.6.2
Ri
 
Sort by date Sort by votes
You have identified the only way. Create new schema, export from the old one into the new one, drop the old one.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question
History log of all SQLs of a particular schema
Replies
2
Views
77
rk68
rk68
AlStl
  • Locked
  • Question
Accessing Objects in another schema under same database 1
Replies
4
Views
47
Beilstwh
Beilstwh
rk68
  • Locked
  • Question
giving user rights to access another schema
Replies
2
Views
43
LKBrwnDBA
LKBrwnDBA
rk68
  • Locked
  • Question
access to procedure from another schema
Replies
1
Views
56
LKBrwnDBA
LKBrwnDBA
grapes12
  • Locked
  • Question
DBMS_SPACE.UNUSED_SPACE schema usage
Replies
5
Views
83
LKBrwnDBA
LKBrwnDBA

Part and Inventory Search

Sponsor

Back
Top