select dbms_utility.port_string from dual;
there is no default location for datafiles (unless using OMF) so you put
them whre you want
On 9/16/05, Eric Buddelmeijer <Eric.Buddelmeijer_at_elegant.nl> wrote:
>
> Ladies, Gents,
> I have a package in use to create a standalone environment (tablespaces
> and schema's) for developers. Some developers install a linux oracle, some a
> windows oracle. They maintain their own installation on laptops and the
> like. Tablespaces are created in the package. In the package I need to know
> if I must use a \ or a / in the path for datafiles. Is there a place in the
> oracle dictionary where I can find out on what platform the current database
> is running? I now use what I would call a workaround by selecting the first
> row from dba_data_files and look for the first character as a tell-tale sign
> for the platform. But in my opinion that is just what it is, a workaround.
> Must be something better available. Can anyone enlighten me?
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 16 2005 - 03:09:19 CDT
