Dear All,

 

I want to know something about indexes. Can anybody tell me preferrably in which tablepsace should be stored? Should it be stored in the USERS tablespace or in the INDX tablespace.

Can anyone also help me with a command by which i can extract the script of all tables and their keys(primary or foreign or unique) and also the indexes.[USING IMPORT AND EXPORT]

 

 

With Regards,

 

Anand