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
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.
A flag to indicate whether full databse export should be performed.
