How to write a trigger in order to invoke a stored procedure in Oracle?
How can we create control file, when it is lost?
Latest Answer: If other files like datafile and log files are intact then take the back up
of the control file to trace directory as follows.
1. Open the database in nomount mode i.e. startup nomount;
2. Take the backup of control file i.e.
ALTER DATABASE BACKUP ...
Explain what are system tablespace and default tablespace? How do they differ from one another?
Latest Answer: System for oracle oracle metadata and default for when you create any user without providing any default tablespace clause will use this tablespace for objects ...
How to start Oracle services manually for Oracle database?
How to cancel an automatic recovery in standby database?
Where can we see the last refreshed details of the Database (from Some other Environment Database) or Restored (from some backup)
A user reports that his database is running slow, after 2 days it runs fast, what is your observation?
The tape device of datafile of 1GB, while you are taking backup to disk, a user enters and access/modifies the database, where will this data be stored?
How to estimate the size of a tablespace according to the size of the database size
Latest Answer: select sum(bytes/1024/1024) mb from dba_data_files where tablespace_name='XXXXXX' ...
How many layers are there in the shared pool? What are they?
Latest Answer: There are two layers in shared pool 1. Library cache2. Data Dictionary cache ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 Next >>
Go Top
