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.
|
|
|