Ask Experts Questions for FREE Help!
Answer   ||    Advanced Search    ||    Help
Ask your question or search...
Login with Facebook
User Name 
Password 
Forgot password? 

Want to become a member? It's free and once you join you can ask and answer questions. Join Now!

Home > Computers & Technology > Programming > Databases > Oracle   »   Copy/Restore Databases in SQL*PLUS

Question
 
 
#1  
Old Jun 12, 2009, 08:18 AM
ashley velez
Junior Member
ashley velez is offline
 
Join Date: Aug 2008
Posts: 60
ashley velez See this member's comment history on his/her Profile page.
Copy/Restore Databases in SQL*PLUS

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?

Reply With Quote
 
     

Answers
 
 
Old Jul 29, 2009, 11:15 AM   #2  
Junior Member
BASIC11 is offline
 
Join Date: Jul 2009
Posts: 1
BASIC11
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.
  Reply With Quote
 
     

Answer this question

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Ask your question or search...

 




Similar Threads
MySQL Databases
(3 replies)
databases and mySQL what?
(1 replies)
when i try to go back to restore point, my comuter doesnt go to restore.
(3 replies)
system restore - unable to restore
(2 replies)
access databases
(1 replies)


Bookmarks and Sharing
bookmark twitter facebook

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Search this Thread

Advanced Search




Copyright ©2003 - 2010 - Advizo, LLC
All times are GMT -8. The time now is 10:58 PM.