SQL>create user <user> identified by <passwd> default tablespace users temporary tablespace temp; User Created SQL>grant connect to <user>; grant successNow when I am trying to import file by giving the command:
SQL>imp <user>/<passwd> file=/home/vikas/<filename.dmp>;It's giving me the error:
Export file created by EXPORT:V09.02.00 via direct path IMP-00013: only a DBA can import a file exported by another DBA IMP-00000: Import terminated unsuccessfullyI am using RedHat Linux EL3 and Oracle 9i.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading