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; ...
It is used to set the optimal length of a rollback segment.
To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage.
Latest Answer : 1.System tablespace is required in all databases.2.It is created with the database.3.Contains the data dictionary and stored program units.4.Contains SYSTEM undo segment. ...
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
The space used transaction entries and a deleted record does not become free immediately after completion due to delayed cleanout. Trailing nulls and length bytes are not stored. Inserts
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.
