Restore oracle dmp file

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Related Hot Network Questions. Question feed. Server Fault works best with JavaScript enabled. How to restore dump file in Oracle 12c Ask Question. Asked 7 years, 3 months ago. Active 3 years, 1 month ago. Viewed 27k times. It would be good if you post the error details in the log. I corrected the errors.

You mean you solved your issue? Could you please edit your question and add the resolution details alongwith the errors you encountered. I meaned i edited my question. I still have trouble with my issue. I already said, it would be good if you post the error details. You will find it in the log file. And post the command you are using. Show 6 more comments. Active Oldest Votes. Add a comment. MSS 3, 22 22 silver badges 25 25 bronze badges. Umesh Acharya Umesh Acharya 21 2 2 bronze badges.

Here is a document about usermanagement in 12c Administering User Accounts and Security The DBA essentials in general is a very good starting point You are looking in the root of a container database and you need to create your users in a local PDB and import your data in there. You are simply assuming things since OP has not mentioned any error details.

You can make use of the same password and log-in detail to get an easy log in within the schema. When the dump file of Oracle successfully gets imported, you can easily see in which schema the file was been imported.

Follow the below steps to manually restore Oracle dmp file to your database:. Login to your SQL command line terminal. If you are using the Windows then open the command prompt or if you are using Linux then open Terminal. To do this follow the below command:. Lastly restore Oracle db dmp file by using the below command:. If you are unable to restore Oracle db dmp file by using the above solution then it is recommended that you must use a third-party Oracle File repair too l.

It is designed to repair and recover corrupted oracle database objects that include oracle DMP files as well. The tool comes with easy to use interface and anyone can easily operate it to restore damaged or corrupted oracle data. It can easily restore all the data of Oracle database such as tables, procedures, queries, XML content, etc. Step 1: Search the Initial screen of Oracle File repair tool with a pop-up window showing options to select or search corrupt Oracle databases on your computer.

Step 2: Click Scan File to initiate the scan process after selecting the oracle database. The recoverable database objects get listed in the left-side pane.