How to set NLS_DATE_FORMAT for a database permanentlyfor example let's say I want to set : NLS_DATE_FORMAT= 'dd:mon:yyyy hh24:mi:ss' for the database and I am not supposed to give the ALTER SESSION command at every statrtup of the database.Plz try it practically and give me a solution

rajat_dua

 Profile Answers by rajat_dua Questions by rajat_dua

• Mar 3rd, 2009

Part of the SGA contains general information about the state of the database and the instance, which the background processes need to access; this is called the fixed SGA. No user data is stored here....

Answer Question  Select Best Answer

How to assign an index tablespace for a database permanently, so that whatever indexes we are creating in the database, should automatically goes to that tablespace i.e. we neednot supply the tablespace name during index creation.

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 17th, 2007

There is no such provision in oracle to have default index tablespace. Workaround is- you can have a job which will scan for indexes in other tablespaces and rebuild into desired one.

Answer Question  Select Best Answer