OraFAQ Forum: Server Administration » How to retrieve the default path for datafiles

Home » RDBMS Server » Server Administration » How to retrieve the default path for datafiles

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Previous Topic:	UTL_FILE Reading More than 1022 Characters
Next Topic:	Database archivelog mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 03:44:08 CDT 2024