Monday, April 20, 2009

Oracle - Default Location for data files

To get the existing location

sql > show parameter db_create;

To set a new location

sql> alter system set db_create_file_dest='/home/ssinghal/oradata';

No comments: