Partition

                                                            PARTITIONING PARTITIONS :         Dividing  the large tables into small tables known as partitions Partition of single table can go in two different tablespaces Sorting can be done by partitioning thus we not require temporary tablespace Partition can be independently managed Backup and recovery… Read More

ORACLE TYPES OF AUDITING

                                                            AUDITING Auditing is for verification purpose     Types of auditing: Privilege level Statement level Object level To enable the auditing  audit_trail=true or db or os To disable the auditing audit_trail=false or none If the value is true it will enable the auditing and audit files… Read More

VI EDITOR COMMANDS

VI EDITOR COMMANDS $vi file1 Default mode will escape mode If u want switch into insert mode We have commands I : Current position insert mode A : at the end of the line insert mode a: next to the current position insert mode s:… Read More

Oracle : STARTUP and SHUTDOWN