×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Oracle DB copy

Oracle DB copy

Oracle DB copy

(OP)
Hi,

I am a newbie in the Oracle world and I got a huge task to do...  I must do a copy of a db to use it on an other system.  How do I do this?

One of my other problem is to find out how to view my tables definitions and my tables content.  I can view those using SQL*PLUS but is there something more user friendly to do it?  I tried the dba studio but for strange reason it's not working...

Thx a lot for your help,
Christian Dionne

RE: Oracle DB copy

1. If you have a working Oracle database on the other system the simplest solution would be to export the relevant tables/schemas and then import them to the new database.

2. If you have to create the database on the new system that would involve installing the Oracle software and creating an instance.  Then you can schedule a time and bring the original database down.  Then copy all the database datafiles, control files, redo log files, and init.ora file to the new system.  If you are lucky enough to have the exact same file structure on both old and new you will probably be able to start the new instance using the copied init.ora file.  Otherwise you will have to make modifications.  Check the init.ora file and change all file names to the new structure (for example, the control file locations).  Then mount the database but do not open it. Modify file names with the command "alter database rename file 'oldfilename' to 'newfilename'".  Finally you can open the database.  If all the details have been taken care of you will have a working duplicate of the original.

There are other approaches and variations, but I've used this method very successfully.  One alternative, if you can't bring the old database down, is to restore files from a backup and forward recover to the point that you want.

RE: Oracle DB copy

(OP)
Thanks a lot for your help.

I think solution #1 will be perfect for me...
And I just found a way to export and import... thx

Any idea for my other problem?
One of my other problem is to find out how to view my tables definitions and my tables content.  I can view those using SQL*PLUS but is there something more user friendly to do it?  I tried the dba studio but for strange reason it's not working...

RE: Oracle DB copy

I think may be you can download the development tools from
WWW.toadsoft.com. TOAD is a Tools for Oracle Application Developers,
where you view your data, column, contrainsts....

I used as my development tools also. i found that it is very useful.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close