Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Oracle (https://www.askmehelpdesk.com/forumdisplay.php?f=443)
-   -   Copy/Restore Databases in SQL*PLUS (https://www.askmehelpdesk.com/showthread.php?t=364177)

  • Jun 12, 2009, 09:18 AM
    ashley velez
    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?
  • Jul 29, 2009, 12:15 PM
    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.
  • Apr 18, 2013, 02:01 PM
    DavieOrnikston
    You can also restore sql databases applying professional recovery tool

    More important information you may dig at ms sql mdf fix

  • All times are GMT -7. The time now is 09:29 AM.