Running Oracle IMP as SYSDBA

oracle imp sysdba
Bob Perkins picture Bob Perkins · Jun 10, 2013 · Viewed 26.4k times · Source

I need to import an ORACLE 9 DMP file into a newly installed Oracle 11g. I'm using the imp utility and using SYSMAN as the login. I get to the point to restore and am told 'only a DBA can import a file exported by another DBA'. When I try and use SYSDBA blank password does not work. When I use SQLPLUS / as SYSDBA and then try and assign a new password I'm told SYSDBA does not exist. If I try and log in as SYS I'm told to login as SYSDBA.

Answer

Smit Patel picture Smit Patel · Sep 5, 2013

Try following syntax to use imp as sysdba:

imp \'sys/sys as sysdba\' file=/oracle/implog.dmp log=imp.log full=y

Related questions

How Can I import or open a .dmp file?

Update: I tried the impdp command and it's giving me that it cannot create a user. I tried creating the user as well This is how my .par file looks like This is a snip of .sh file I have …

Read More
Oracle imp and exp commands

Normally when i have to take a backup of of a database on unix, i do, exp DBUSER/DBPSW@INST file=xxx.dmp or load from a dump imp DBUSER/DBPSW@INST file=xxx.dmp my question here is : how …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More