Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Using OS info in package, OFA from within database

Re: Using OS info in package, OFA from within database

From: David Sharples <davidsharples_at_gmail.com>
Date: Fri, 16 Sep 2005 09:06:42 +0100
Message-ID: <be592d55050916010648d5a24e@mail.gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US