Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Copy and move entire database

418779Nov 11 2009 — edited Nov 12 2009
I have a database setup in Oracle 11 that contains 4 tablespaces, 4 users, about 50 tables and some other objects like views, triggers, sequences, etc.
What i would like to do is take that db in the state it is in and copy it and move it in it's entirety to another machine and then set it up on that machine so i have a carbon copy. It would ne great if this was simple and painless because i may need to do it several times and on short notice.
I am from a sql sever background and there i would simply detach the db and copy the files over to the new machine and then reattach it.
Is there a simple way to achieve similar with Oracle?
I use the web-based manager and Aqua Data Studio for most of my database manipulation tasks.
thanks for any suggestions.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 10 2009
Added on Nov 11 2009
#general-database-discussions
19 comments
1,484 views