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';
Technical tid-bits and more ! Leave a comment if you found something useful.
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';
0 comments:
Post a Comment