Somewhat off topic.
We had a Windows server with Oracle 11g r0 (?)
We had an automated routine (via .bat file ) that did an EXP of one table from a
specific schema (i.e. TEST) using just the password/schema
TEST had a DBA role at the time.
We set up a brand new linux box with Oracle 11g (latest release), same schema
names but not with DBA role.
We utilized TOAD to try and import into TEST as TEST. It errors saying that it
was exported with DBA rights and it can not be imported because the user
doesn’t have DBA rights.
The new environment folks do not wish to have the schemas have DBA roles –
I can understand.
What’s going on?
We take files in and out all day, so importing as DBA then exporting without DBA
is not an option right now.
Is there any work around to get those files in without DBA rights ?