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!

Copy Data Base 1

Status
Not open for further replies.
jpernia

jpernia

Technical User
Mar 29, 2002
35
US
Hi all, someone know how can i copy a databse to other machine and change the name of the DB (Copy all .dbf not export and import)

thanks
 
Sort by date Sort by votes
I've seen it suggested in another thread that "alter database backup controlfile to trace" will give you a script in which you can change the dbname by recreating the control files. I've never done it myself. (You will probably want to change the global & service names in init.ora too). DaPi - no silver bullet
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
149
TheLazyPig
TheLazyPig
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
102
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
341
Andrzejek
Andrzejek
rk68
  • Locked
  • Question
inserting multi lingual data
Replies
0
Views
81
rk68
rk68
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
399
carp
carp

Part and Inventory Search

Sponsor

Back
Top