|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop Latest Answer : If its the same database use:alter table the_table move tablespace other_tablespace; alter index the_index rebuild tablespace other_tablespace; ... We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can - Logical Backups - Cold Backups - Hot Backups (Archive log) Latest Answer : 1. Physical Backup---Hot Backup---Cold Backup2. Logical Backup---Export---Import ... Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup. Latest Answer : The simple example for logical backup is export and import. The logical backup involves in taking the snapshot of the database at that particular instance in terms of series of SQL statements which is not a byte-by-byte copy of the database. This is obvious ... Tags : Backup Full back - Complete databaseIncremental - Only affected tables from last incremental date/full backup date.Cumulative backup Latest Answer : Different kinds of Exports are:1. Owner(Schema) level Backup2. Object(table) level backup3. Full Backup4. Tablespace Level Backup ... To give the export file name. Flag to indicate whether export should compress fragmented segments into single extents. A flag to indicate whether full databse export should be performed. Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL. For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
