Recover deleted data from a table in oracle with flashback
If you deleted records in an oracle table that you did not intend to, oracle flashback may be of assistance.
You might need to alter the table to enable row movement.
Tags
oracle
oracle query to check all tables a user has select privilege to
Query to check all tables with select privileges assigned to a user in oracle.
changing oracle user profile and expired status
I recently had an oracle user(schema) that was created with a profile of 'DEFAULT' which meant the user's password would expire. The user should have been created with a profile that does not expire its password. Well, the password expired and I have to change the password without actually changing it.
Tags
REP-0178: Reports Server cannot establish connection.
While trying to run Oracle Report services from from the command line i received the following error.
REP-0178: Reports Server cannot establish connection.
Tags