oracle-dba-online.com

• content: text/html; charset=utf-8 equiv: Content-Type
• name: viewport content: width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no
• content: oracle dba, Oracle 12c, Oracle 11g, Oracle10g, Oracle 9i, Oracle 8i, tutorial, import, tablespace, database, datafile, logfile, controlfile, creating database, undo tablespace, logminer, log miner, data pump name: keywords
• content: Learn Oracle 11g / 12c DBA Step by Step with Examples. It's Free and Covers Basic as well as Advance Oracle DBA topics. name: description
• equiv: origin-trial content: AlK2UR5SkAlj8jjdEc9p3F3xuFYlF6LYjAML3EOqw1g26eCwWPjdmecULvBH5MVPoqKYrOfPhYVL71xAXI1IBQoAAAB8eyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiV2ViVmlld1hSZXF1ZXN0ZWRXaXRoRGVwcmVjYXRpb24iLCJleHBpcnkiOjE3NTgwNjcxOTksImlzU3ViZG9tYWluIjp0cnVlfQ==
• equiv: origin-trial content: Amm8/NmvvQfhwCib6I7ZsmUxiSCfOxWxHayJwyU1r3gRIItzr7bNQid6O8ZYaE1GSQTa69WwhPC9flq/oYkRBwsAAACCeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiV2ViVmlld1hSZXF1ZXN0ZWRXaXRoRGVwcmVjYXRpb24iLCJleHBpcnkiOjE3NTgwNjcxOTksImlzU3ViZG9tYWluIjp0cnVlfQ==
• equiv: origin-trial content: A9nrunKdU5m96PSN1XsSGr3qOP0lvPFUB2AiAylCDlN5DTl17uDFkpQuHj1AFtgWLxpLaiBZuhrtb2WOu7ofHwEAAACKeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9
• equiv: origin-trial content: A93bovR+QVXNx2/38qDbmeYYf1wdte9EO37K9eMq3r+541qo0byhYU899BhPB7Cv9QqD7wIbR1B6OAc9kEfYCA4AAACQeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9
• equiv: origin-trial content: A1S5fojrAunSDrFbD8OfGmFHdRFZymSM/1ss3G+NEttCLfHkXvlcF6LGLH8Mo5PakLO1sCASXU1/gQf6XGuTBgwAAACQeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQUlQcm9tcHRBUElNdWx0aW1vZGFsSW5wdXQiLCJleHBpcnkiOjE3NzQzMTA0MDAsImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9

• Home
• Tutorial for Oracle SQL
• 60 Technical Questions
• 42 Backup & Recovery Questions
• Unix For Oracle DBA 20 Questions
• Links to Download Oracle 12c / 11g for Linux, Windows etc.
• Learn MySQL step by step
• Introduction to Oracle Database
• Overview of Oracle Grid Architecture
• Difference between a cluster and a grid
• Responsibilities of Database Administrators
• Creating Oracle 11g / 10g Database using SQL commands
• Creating Oracle Container Database in 12c using DBCA
• Creating Oracle Container Database in 12c using SQL commands
• Creating User Accounts and Connecting to Oracle 12c Container and Pluggable Databases
• Creating Pluggable Database from Seed
• Cloning an Existing Pluggable Database
• Unplugging and Plugging databases from one CDB to another CDB
• http://oracle-dba-online.com/tablespaces_and_datafiles.htm
• Creating  New Tablespaces
• Bigfile Tablespaces (Introduced in Oracle Ver. 10g)
• To Extend the Size of a tablespace
• To decrease the size of a tablespace
• Coalescing Tablespaces
• Taking tablespaces Offline or Online
• Making a Tablespace Read only.
• Renaming Tablespaces
• Dropping Tablespaces
• Viewing Information about Tablespaces and Datafiles
• Relocating or Renaming Datafiles
• Renaming or Relocating Datafiles belonging to a Single Tablespace
• Procedure for Renaming and Relocating Datafiles in Multiple Tablespaces
• Temporary Tablespace
• Increasing or Decreasing the size of a Temporary Tablespace
• Tablespace Groups
• Creating a Temporary Tablespace Group
• Assigning a Tablespace Group as the Default Temporary Tablespace
• http://oracle-dba-online.com/repair-tablespaces.htm
• Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap)
• Scenario 2: Dropping a Corrupted Segment
• Scenario 3: Fixing Bitmap Where Overlap is Reported
• Scenario 4: Correcting Media Corruption of Bitmap Blocks
• Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed Tablespace
• http://oracle-dba-online.com/transporting-tablespaces-in-oracle.htm
• Procedure for transporting tablespaces
• Transporting Tablespace Example
• http://oracle-dba-online.com/managing_redo_logfiles.htm
• Adding a New Redo Logfile Group
• Adding Members to an existing group
• Dropping Members from a group
• Dropping Logfile Group
• Resizing Logfiles
• Renaming or Relocating Logfiles
• Clearing REDO LOGFILES
• Viewing Information About Logfiles
• http://oracle-dba-online.com/managing_control_files.htm
• Multiplexing Control File
• Changing the Name of a Database
• Creating A New Control File
• Cloning an Oracle Database
• Viewing Information about Undo Tablespace
• Restrictions on Using Direct Path Loads
• Example: Migrate Data from Fixed Length file into Oracle
• Example: Convert from MySQL to Oracle
• Example: Migrating data from MS SQL Server to Oracle
• Loading Data into Multiple Tables using WHEN condition
• http://oracle-dba-online.com/export_and_import.htm
• Invoking Export and Import
• Command Line Parameters of Export tool
• Example of Exporting Full Database
• Example of Exporting Schemas
• Exporting Individual Tables
• Exporting Consistent Image of the tables
• http://oracle-dba-online.com/how-to-use-import-tool.htm#Using_Import_Utility
• Example Importing Individual Tables
• Example, Importing Tables of One User account into another User account
• Example Importing Tables Using Pattern Matching
• Migrating a Database across platforms
• http://oracle-dba-online.com/data_pump_utility.htm
• Using Data Pump Export Utility
• Example of Exporting a Full Database
• Example of Exporting a Schema
• Exporting Individual Tables using Data Pump Export
• Excluding and Including Objects during Export
• Using Query to Filter Rows during Export
• Suspending and Resuming Export Jobs (Attaching and Re-Attaching to the Jobs)
• http://oracle-dba-online.com/data_pump_import_utility.htm
• Importing Full Dump File
• Importing Objects of One Schema to another Schema
• Loading Objects of one Tablespace to another Tablespace
• Generating SQL File containing DDL commands using Data Pump Import
• Importing objects of only a Particular Schema
• Importing Only Particular Tables
• Running Import Utility in Interactive Mode
• http://oracle-dba-online.com/flash_back_features.htm
• Flashback Query
• Using Flashback Version Query
• http://oracle-dba-online.com/#_Toc176874882
• Using Flashback Table to return Table to Past States
• Purging Objects from Recycle Bin
• Flashback Drop of Multiple Objects With the Same Original Name
• Example: Flashing Back Database to a point in time
• Enabling Flash Back Database
• ntroduction
• Creating Flashback Data Archive tablespace
• Creating Flashback Data Archive
• Querying historical data 
• http://oracle-dba-online.com/log_miner.htm
• LogMiner Configuration
• LogMiner Dictionary Options
• Using the Online Catalog
• Extracting a LogMiner Dictionary to the Redo Log Files
• Extracting the LogMiner Dictionary to a Flat File
• Redo Log File Options
• Example: Finding All Modifications in the Current Redo Log File
• Example : Mining Redo Log Files in a Given Time Range
• Bringing the Database again in NoArchiveLog mode
• Opening the Database in Archivelog Mode
• Taking Offline (COLD) Backups
• Taking Online (HOT) Backups
• Recovering from the Loss of a Datafile
• When the Database is running in Noarchivelog Mode
• When the Database is running in Archivelog Mode
• Recovering from loss of Control File
• Taking Offline Backups using RMAN
• Recovering the Database running in NOARCHIVELOG mode using RMAN
• Taking Online Backups using RMAN
• Taking backups of particular tablespaces or datafiles using RMAN
• How to take Image Backups in RMAN
• Taking Incremental Backup using RMAN
• Incrementally updating backup copy for fast recovery
• View information about RMAN backups
• Configuring Retention policy in Oracle RMAN
• Configure various Options in RMAN
• Maintaining RMAN Repository
• Recovering from the loss of datafiles using RMAN (Archivelog mode)
• Recovering from the loss of datafile by changing it's location
• Performing Disaster Recovery using RMAN
• Contact Us
• Политика конфиденциальности

• Convert MS SQL to MySQL
• Convert MS Access to MySQL
• Convert MS Access to MSSQL
• Convert CSV to MySQL
• Convert Foxpro to MySQL
• Convert Foxpro to MSSQL
• Convert MS Access to Oracle
• Convert MSSQL to Oracle
• Convert CSV to Oracle
• Data Loader
• Forms Data Loader
• https://statcounter.com/free-hit-counter/

            Domain Name: ORACLE-DBA-ONLINE.COM

Registrar: GoDaddy.com, LLC

Domain Status: client delete prohibited

Domain Status: client renew prohibited

Domain Status: client transfer prohibited

Domain Status: client update prohibited

Creation Date: 2007-05-18T15:51:52Z

Registry Expiry Date: 2029-05-18T15:51:52Z

Updated Date: 2026-05-07T09:44:59Z

Name Server: NS1.DNS-PARKING.COM

Name Server: NS2.DNS-PARKING.COM

REGISTRAR Contact: GoDaddy.com, LLC

>>> Last update of RDAP database: 2026-07-26T05:55:14Z         

			User-agent: *
Disallow: