Latest Answer : in 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong ...
What is the differences between DBMS & RDBMS? What is the differences between Oracle & MS Access?
what is Referential Backup? Which case we use Referential Backup and which case we use Incremental backup?
Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS?
Latest Answer : ofcourse Ascending ...
Latest Answer : Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's will be get in the datafiles.To release the headers from ...
Can we read Control file? If yes, then how?
Latest Answer : SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.
...
what are the necessary steps to be take when server gets down? How can we increase size of a database?
Latest Answer : 1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring up the listener. 6.Check whether the tablespace ...
HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505:
Latest Answer : Just check your port number if two database are in one PC the port number is changed. ...
.
Latest Answer : In Oracle 10G we do not have Bitmap Index . Bitmap index is available only in Oracle9i Enterprise Edition ...
