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; ...
When Segment is dropped.When Shrink (RBS only)When truncated (TRUNCATE used with drop storage option)
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
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 grants on databse objects will be exported or not. Value is 'Y' or 'N'.
A flag to indicate whether indexes on tables will be exported.
Flag to indicate whether table rows should be exported. If 'N' only DDL statements for the database objects will be created.
A flag to indicate whether constraints on table need to be exported.
