Database buffers are cache in the SGA used to hold the data blocks that are read  from  the  data  segments in the database such as tables, indexes and clusters DB_BLOCK_BUFFERS 

 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; ...

List the Optional Flexible Architecture (OFA) of Oracle database? or How  can  we  organize  the  tablespaces in Oracle database to have maximum performance ?

 SYSTEM - Data dictionary tables.DATA  - Standard operational tables.DATA2- Static tables used for standard operationsINDEXES - Indexes for Standard operational tables.INDEXES1 - Indexes of static 

 Limit the number of extents in the tableSeparate Table from its indexes.Allocate Sufficient temporary storage. 

 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.