Oracle Database 10g is an Relational Database or RDBMS. There are two part of this RDBMS and they are Physical Database and Oracle Instance. Physical files, redo log files and control file are comutatively called as physical database. Oracle instance consists of a big memory area and some background process. It provide a way to the users to do an activity on the data. i.e. to retrive, add, modify or delete.
Data files - Physically stores the data
Redo log file - It contains the changes made to data. It is required for recovery.
Control files - It contains tipical information about database
Data files - Physically stores the data
Redo log file - It contains the changes made to data. It is required for recovery.
Control files - It contains tipical information about database
- Datafile location
- Synchronization Information
- Backup and recovery information
Supporting files i.e. parameter file, password file, alert log are important to database but is not a part of the database.
Naming convention of the database objects
- Max 30 characters are supported
- It have to start with a latter
- Can include latter, number and underscore
- Should not user reserved words
No comments:
Post a Comment