I have just installed Oracle 11g on Win64, and I want to import some
I am trying with the tool Oracle Enterprise Manager 11g:
If I log in with SYS as SYSADMIN, and go to
Import from Export Files, I am told
Role Error. Export and Import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and login using a different role before trying again.
If I log in with SYSMAN as Normal, the
Import from Export Filesscreen shows no error, but when I click
Create Directory Objectthen
OK, I get:
Errors. Failed to commit: ORA-01031: insufficient privileges. You are not logged in with SYSDBA privilege. You cannot assign privileges to directory object.
I tried creating a "Directory Object" as Normal, but unfortunately it is not visible under SYSADMIN.
How can I use this
Import from Export Files screen ?