Home » RDBMS Server » Server Administration » How to retrieve the default path for datafiles
How to retrieve the default path for datafiles [message #371070] Tue, 22 August 2000 10:31
Paul
Messages: 164
Registered: April 1999
Senior Member
Hi All,
running the following statement on 3 NT machines:
CREATE TABLESPACE new_user_DATA
DATAFILE 'new_user_DATA' SIZE _tec_size....etc...

in 2 pc the datafile is created under c:\orant\database but in the 3rd pc, the datafile is created under c:\winnt\system32.
Could someone tell me how is it possible to retrieve the default path where the datafile will be created when it's not specified ?
Thanks in advance...ciao,
Paul

p.s. Also using select * from dba_data_files I don't have the full path where the files has been created but just its name.
Previous Topic: UTL_FILE Reading More than 1022 Characters
Next Topic: Database archivelog mode
Goto Forum:
  


Current Time: Tue Oct 20 09:35:29 CDT 2020