I've been trying to restore this dump file, but unfortunately, whoever did the exporting did not make it clear on what users, privileges, and roles are required for the database.
So I thought I'd just create a random user, import it there, look at the errors, and see what I can do.
During the import process, Oracle asked for
system's username and password. I, thinking that it merely needed that for authentication, obliged.
What happened instead was that the dump file's database tables were restored to the user
Now, I may not know much about Oracle, but I can guess that this is probably bad. Really bad. I'm looking at Oracle SQL Developer, and I can see a LOT of tables that probably aren't supposed to be there - I'm pretty sure ACCRUALRULE is not an Oracle system table.
How do I fix this? Is there a way to reset the user
system back to its default setting? I'd hate to have to manually get rid of every table, especially considering I don't know which ones are supposed to stay there.
- Windows 7
- Oracle 11g XE