435 reputation
26
bio website
location Idaho Falls, ID
age
visits member for 3 years, 7 months
seen Aug 4 at 21:06

Jan
2
comment How to rollback last executed sql script fired as sysdba
As I said, you might be able to undo your changes with flashback, although since you used SYSDBA to do it, this could be problematic. Other than that, I see no other option. I seriously doubt that a database restore is what you're looking for. Amen to David Aldridge's comment about possibly getting fired for a mistake like this. I would add that perhaps the DBA should be fired for giving you access to this account :-)
Jan
2
answered How to rollback last executed sql script fired as sysdba
Nov
20
revised How can I find who has allocated a user lock via dbms_lock?
added 100 characters in body
Nov
20
comment How can I find who has allocated a user lock via dbms_lock?
Thanks, Phil. I've seen that suggestion before, but it does not show any locks of that type.
Nov
20
asked How can I find who has allocated a user lock via dbms_lock?
Oct
26
comment I am getting error ORA-03113 at the time of startup database.
Not archive log, ALERT log.
Oct
26
comment I am getting error ORA-03113 at the time of startup database.
Look in the alert log.
Mar
22
awarded  Yearling
Mar
22
answered Materialized view log not updating
Mar
22
revised Materialized view log not updating
edited tags
Mar
22
revised Materialized view log not updating
edited tags
Mar
22
revised Materialized view log not updating
added 44 characters in body
Mar
22
asked Materialized view log not updating
Dec
28
comment RMAN backup script failing
I think it should work. Try it and see. You don't even need to actually run the backup stuff to examine the environment variables.
Dec
28
answered RMAN backup script failing
Aug
19
comment Oracle startup error: “end-of-file on communication channel”
Have you checked the alert log for the database?
Apr
17
answered ORA-39142: incompatible version number 3.1 error work-around
Mar
17
awarded  Yearling
Dec
22
comment What is Utility_DSN?
Better late than never! Thanks for the reply. I have not consciously made use of any connections to non-oracle databases that I know of. Perhaps something was installed on these servers that caused this entry to be created. At any rate, I now have something to look for. This is a Windoze shop, so /etc/oratab isn't in play. Good info, thanks again.
Dec
22
accepted What is Utility_DSN?