PDA

View Full Version : Copy/Restore Databases in SQL*PLUS


ashley velez
Jun 12, 2009, 09:18 AM
A customer of mine is running a different installation of Oracle(9)than I have seen. Usually I see SQL Developer installed, which is a GUI very similar to MS SQL Server Management Studio, but this customer doesn't seem to have that. I need to copy one database to another. Can I do that using SQL PLUS? Alternative method, Can I restore a database in SQL PLUS using a back up from another database? If so how exactly do I do that? What commands do I type?

BASIC11
Jul 29, 2009, 12:15 PM
Yes, you may use SQL Plus assuming you have an account with privileges on the source database. Have you tried Oracle's imp/exp command? The exp command will export the database to a flat file. Then you may use that exported file to do an import on your source server/pc.

DavieOrnikston
Apr 18, 2013, 02:01 PM
You can also restore sql databases applying professional recovery tool

More important information you may dig at ms sql mdf fix (http://www.sqlserver.fixtoolboxx.com/)