Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing data from a data-backup file

580805Aug 1 2007 — edited Aug 1 2007
Hi,
my application runs external process that imports (should import) data from a backup file created using the exp command. Export file is created by gDBUser from global database (GDB) and should be imported by lDBUser to local database (LDB).

process1.StartInfo.FileName = "imp.exe";
process1.StartInfo.Arguments = String.Format(" userid=\\\"{0}/{1}@{2} as SYSDBA\\\" fromuser={3} touser={4} tables=({5})", dbUserName, dbUserPass, serviceName, fromDBUser, toDBUser, tableNames);

process1.StartInfo.UseShellExecute = false;
process1.Start();


Everything works fine as long as the user running my application is member of the DBA system (Windows) group. Unfortunately, in most cases the user does not belong to that group and import fails with the following error message:

IMP-00058: ORACLE error 1031 encountered
ORA-01031: insufficient privilegesUsername:
IMP-00000: Import terminated unsuccessfully

Users should not be members of the DBA group in order not to be able to modify the data otherways then by using the app. They don't even know the dbUserName nor dbUserPass.
Is there a way to be able to perform such import without running it as member of DBA group?

I'll appreciate your help.
Best regards
Rob
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2007
Added on Aug 1 2007
3 comments
1,293 views