Hello All,
I'm getting confused here.
A customer gave us an export .dmp file which we had to import into a db at our office to run some tests on it.
We've done this on a weekly basis and it always went perfect.
Create an empty db from the same old script and import the dump into it. painless & proven working.
Now however we had a load of problems importing it, after looking into it it turned out that I had to create a OPS$ORACLE user in the new database and grant it DBA roles, only then system/manager would import the dumpfile and all tables for every user.
Now this customer is saying to me that their DBA's tells them that he always done the export as the OPS$ORACLE user for the last year and are now acusing me of actually never importing the db hence not doing my job.
But, up untill 1 week this worked perfectly, all their old dump files import without a problem, but this one doesn't.
Am I missing something here ?
Any thought on it is more then welcome :/
Iga
I'm getting confused here.
A customer gave us an export .dmp file which we had to import into a db at our office to run some tests on it.
We've done this on a weekly basis and it always went perfect.
Create an empty db from the same old script and import the dump into it. painless & proven working.
Now however we had a load of problems importing it, after looking into it it turned out that I had to create a OPS$ORACLE user in the new database and grant it DBA roles, only then system/manager would import the dumpfile and all tables for every user.
Now this customer is saying to me that their DBA's tells them that he always done the export as the OPS$ORACLE user for the last year and are now acusing me of actually never importing the db hence not doing my job.
But, up untill 1 week this worked perfectly, all their old dump files import without a problem, but this one doesn't.
Am I missing something here ?
Any thought on it is more then welcome :/
Iga