I have fired one sql script as sysdba which I have to fire using other oracle user.
I have already created some user and each application running on each oracle user. By mistake I had fired a script using one particular user but I have fired it using sysdba.
- How to find .dbf file of sysdba user.
- Can I revert my changes.
- Does it affect other application.
- I have list of tables and sequences. Can I drop individual table and sequence?
- Do you have any better solution.
That script created lots of tables and sequences and inserted data into some tables.