CONTROL FILES How to manage Control Files?? We have discussed briefly the role of control file in an Oracle Database.The control file of an Oracle database is created at the same time as the database.A control file is a small

CONTROL STRUCTURES PL/SQL Tutorials – CONTROL STRUCTURES In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN. Let me remind you that Boolean means to me not TRUE/FALSE but also NULL. This is true always. IF-THEN and ELSE when you

CREATE DATA BASE (1) you must be logged in as SYS with SYSDBA privilege invoked. (2) you must have edited initmynewdb.ora file to spawn an oracle instance (3) and you started the oracle instance in nomount mode. (4) after the

CSSCAN (Character Set Scanner) Introduced in Oracle 8iR2 Metalink Doc Id 123670.1 Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character

DATA FILES How to manage datafiles?? The earlier discussions are on the control files and redo log files as also archived log files. Control files and redo log files are part of the database files and they count as part