All-in-One Guides:Database storage management
Backing up your Oracle data
The export utility
Using export is not recommended as the sole backup method, but this option can be useful for particular situations. (Whenever exporting, you should configure the CONSISTENT=Y parameter.) With export, you can perform incremental backups, create a backup of a table with LONG or LONG RAW columns, and back up a single table. These links explain how. Make sure to first find out what data files you need, and then follow these step-by-step instructions for copying a database or schema.
-
Ask the Expert - Brian Peasland explains how to use the export utility to create a logical backup of a table.
-
Creating a backup of a table that contains a LONG type field
Ask the Expert - I need to take a backup of a selected number of rows from an Oracle table. I thought of doing a create table ... as select from. However, the source table consists of a LONG type field. How can I back this up? Can I use export?
-
Performing incremental exports
Ask the Expert - Can I perform incremental exports? How?
-
Backing up tablespace without exp80 and imp80
Ask the Expert - Find out what datafiles you need with these queries before backing up with exp and imp.
-
Steps for copying a database or schema
Ask the Expert - Follow these steps to copy an entire database or a schema using Oracle's export and import utilities.
-
Clone database with exp/imp on Linux
Ask the Expert - Is it possible to clone an Oracle 10g database from Linux (R3 update4) server to IBM Blade Server under Linux AS4 with exp/imp?
-
Using 'consistent=y' in exports
Ask the Expert - Given that export is now not recommended as a backup mode, what is the effect of the 'consistent=y' parameter when data is exported?
-
Copying database structure without data
Ask the Expert - I want to take the structure of my database, but not the data. Is it possible?
Oracle Applications - JDE, PeopleSoft, Hyperion, BI