Q
Problem solve Get help with specific problems with your technologies, process and projects.

IMP errors with schema import

We exported a schema in Unix. When we tried to import it in another database it said: 1) IMP-00002: fail to open; for read at DOS prompt. 2) IMP-00013: only a DBA can import a DBA exported file.

We exported a schema in Unix for about 2.5GB. When we tried to import it in another database it said: 1) IMP-00002: fail to open; for read at DOS prompt. 2) IMP-00013: only a DBA can import a DBA exported file. Please let me know the possible options of how to import.
The IMP-00013 error is telling you the problem: "only a DBA can import a DBA exported file." When you perform the import process, specify either SYS or SYSTEM for the USERID parameter, and you will not receive this error.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close