Exports can be Done in 4 Levels

Exports can be done at 4 Levels. Table-Level User-Level TABLESPACE level DB-Level (You need DBA Privilege) When we are doing at Table-Level, we can mention either one or More Tables according our need. Similarly, same rule applies to (B) also. But, we can’t be choosy at different Levels with different …

Read More »

Exports & Imports

Primarily there are 2 backup methods in Oracle. Logical (using Exports – Only on Logical objects) Physical (a. COLD-Bkup & b. HOT-Bkup) Though every night we do Physical backups, it’s very important that you must perform logical backup also, which in a way serves as standby bkup in case of …

Read More »

SQL Server Error Logs Detailed Information

SQL Server Error Logs

SQL Server Error Logs * Error Logs maintains events raised by SQL Server server or SQL Server Agent. * Error Logs is main source for troubleshooting and identifying SQL Server problems. * SQL Server supports 2 types of type error logs * SQL Server Logs * SQL Agent Logs Questions …

Read More »

Redo Logfile Management

What Is the Redo Logfile ? The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the …

Read More »

Control File Management

What Is a Control File ? Every Oracle Database has a control file, which is a small binary file that records the physical structure of the database. The control file includes: The database name Names and locations of associated datafiles and redo log files The timestamp of the database creation …

Read More »

Undo Tablespace

When a query tries to modify database, original data entries are kept in separate location and then changes are applied to data files. The data which is kept in separate location is called Undo data. Undo data is used to maintain data integrity and data consistency. Oracle uses Undo data …

Read More »

Managing Security for Oracle Database Users

About User Security Each Oracle database has a list of valid database users. To access a database, a user must run a database application, and connect to the database instance using a valid user name defined in the database. Oracle Database enables you to set up security for your users …

Read More »

Oracle Tablespace Management

WHAT IS MEANT BY TABLE SPACE? Table space is nothing but logical representation of data in oracle database. Database is divided into one or more logical storage units called Table spaces. Table spaces are where you store Oracle database objects such as tables, indexes and rollback segments. A table space …

Read More »

Database Startup and Shutdown

1)STARTUP NO MOUNT: In the NO MOUNT level, only the Oracle INSTANCE is started. To do so Oracle looks for the Instance parameter file and starts all Processes and Memory Structures. SQL> startup nomount ORACLE instance started. Total System Global Area 732352512 bytes Fixed Size 1339036 bytes Variable Size 440402276 …

Read More »
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.