Oracle DB copy 1

[onirike]

Hi,<br><br>I am a newbie in the Oracle world and I got a huge task to do...&nbsp;&nbsp;I must do a copy of a db to use it on an other system.&nbsp;&nbsp;How do I do this?<br><br>One of my other problem is to find out how to view my tables definitions and my tables content.&nbsp;&nbsp;I can view those using SQL*PLUS but is there something more user friendly to do it?&nbsp;&nbsp;I tried the dba studio but for strange reason it's not working...<br><br>Thx a lot for your help,<br>Christian Dionne

 

[karluk]

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.<br><br>2. If you have to create the database on the new system that would involve installing the Oracle software and creating an instance.&nbsp;&nbsp;Then you can schedule a time and bring the original database down.&nbsp;&nbsp;Then copy all the database datafiles, control files, redo log files, and init.ora file to the new system.&nbsp;&nbsp;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.&nbsp;&nbsp;Otherwise you will have to make modifications.&nbsp;&nbsp;Check the init.ora file and change all file names to the new structure (for example, the control file locations).&nbsp;&nbsp;Then mount the database but do not open it. Modify file names with the command &quot;alter database rename file 'oldfilename' to 'newfilename'&quot;.&nbsp;&nbsp;Finally you can open the database.&nbsp;&nbsp;If all the details have been taken care of you will have a working duplicate of the original.<br><br>There are other approaches and variations, but I've used this method very successfully.&nbsp;&nbsp;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.

 

[onirike]

Thanks a lot for your help.<br><br>I think solution #1 will be perfect for me...<br>And I just found a way to export and import... thx<br><br>Any idea for my other problem?<br>One of my other problem is to find out how to view my tables definitions and my tables content.&nbsp;&nbsp;I can view those using SQL*PLUS but is there something more user friendly to do it?&nbsp;&nbsp;I tried the dba studio but for strange reason it's not working...<br><br>

 

[leachoo]

I think may be you can download the development tools from <br><A HREF="

http://WWW.toadsoft.com"

TARGET="_new">

http://WWW.toadsoft.com</A>.

TOAD is a Tools for Oracle Application Developers,<br>where you view your data, column, contrainsts....<br><br>I used as my development tools also. i found that it is very useful.