Importing data from a data-backup file
580805Aug 1 2007 — edited Aug 1 2007Hi,
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