HDTenEightyP/NetNews huggingface dataset:
From: rsnyder@ems.cdc.com (Richard Snyder)
Newsgroups: comp.databases.oracle
Subject: Importing files from LOTUS
Keywords: LOTUS, IMPORT, ORACLE
Date: 4 Jan 93 16:29:50 GMT
Reply-To: rsnyder@ems.cdc.com
Organization: Empros Systems International, a division of Ceridian

We have an application that requires data to be imported to Oracle 
tables from a LOTUS spreadsheet.  I don't believe there is any
Oracle utility to do this. However, I would like the benefit of others
experience as to how to go about this. The following comes to mind:

1) Are there any Oracle utilities to do the import written by 
   Oracle, LOTUS or others?
2) If not what is the best approach to import the LOTUS data?
   a) Write a script in LOTUS to do the import directly.
   b) Put the LOTUS data into a flat file and then reformat the flat
      file to an Oracle Import format.
   c) Some other method.

Any information, ideas, experience will be helpful.

 Thanks,
  
 Richard Snyder
 rsnyder@ems.cdc.com

Empros Systems International division of Ceridian Corp.

(612)553-4327

    
Newsgroups: comp.databases.oracle
From: bourasse@cicb.fr (Claude Bourasseau - CICB Rennes 99.84.71.24)
Subject: Oracle and SUN Solaris 2	
Organization: CICB, Universite' de Rennes I, FR
Date: Thu, 7 Jan 1993 12:15:41 GMT

We use ORACLE RDBMS 6.0.33 on several Suns under SunOS 4.1.1 or SunOS 4.1.2.

SUN announces its new OS : SOLARIS 2; What about ORACLE under this new
major release ?

Thanks in advance.

-- 
---------------------------------------------------------------------------
Claude Bourasseau      CICB Campus de Beaulieu   35042 Rennes Cedex  FRANCE
Tel: +33 99 84 71 24   Fax: +33 99 84 71 11      E-mail: bourasse@cicb.fr

Newsgroups: comp.databases.oracle
From: cgraham@convex.com (Chip Graham)
Subject: DOUG Meetings
Organization: CONVEX Computer Corporation, Richardson, Tx., USA
Distribution: USA
Date: Mon, 11 Jan 1993 13:04:38 GMT
X-Disclaimer: This message was written by a user at CONVEX Computer
              Corp. The opinions expressed are those of the user and
              not necessarily those of CONVEX.

Does anyone in the Dallas area know when the next DOUG meeting is? I have 
paid my dues twice, and called the DOUG people several times, but I still
do not get a newsletter.  I guess my next hope is to run for an office,
then maybe I'll get some info! (NOT!)

-- 
Chip Graham      cgraham@convex.com         +1 214 497 4642
Convex Computer Corporation 
3000 Waterview Parkway     
Box 833851, Richardson,Tx,75083
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: 40 values in desc order
Date: 4 Jan 93 15:40:17 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <Bzo2t0.67@lut.fi>, hietanen@lut.fi (Pentti Hietanen) writes:
> 
> What kind of sql sentence should we use to get 40 values
> from database in descending order?
> 
> Pentti Hietanen, student of Lappeenranta University of Technology, Finland.
> internet: hietanen%lut.fi


Probably the easiest way is to use the ROWNUM function.  For example,

	SELECT field1, field2, fieldn
	FROM   the_table
	WHERE  ROWNUM < 40;

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
From: ole@dc.dk
Newsgroups: comp.databases.oracle
Subject: Re: ORACLE ftp sites
Keywords: This field is intentionally left blank
Date: 11 Jan 93 08:27:00 GMT
Organization: Datacentralen A/S

In article <1993Jan8.230350.4281@kakwa.ucs.ualberta.ca> oschnire@handlova.ucs.ualberta.ca writes:
>In  <31367@nntp_server.ems.cdc.com>  btreuman@ems.cdc.com (Bob Treumann) writes:
>> In article <479@ptt-iat>, roo@ptt-iat (? Roo) writes:
>> |> Hi,
>> |> I'm looking for ftp sites where I can find ORACLE stuff.
>> |> Especially I'm looking for DBA utilities.
>> |> Can anyone e-mail the addresses of some sites to me ?
>> |> Thanks in advance
>> |> Peter de Roo.
>>  
>>  
>> I would like to know this too.  
>>      
So would I !!!!
Newsgroups: comp.databases.oracle
From: raja@well.sf.ca.us (Rajasimha Aji)
Subject: References in SQL*FORMS
Organization: Whole Earth 'Lectronic Link
Date: Tue, 5 Jan 1993 23:41:57 GMT



I have used the "REFERENCE" feature of SQL*FORMS 3.0. While specifying
the reference you have to give the username of the form owner in the
database. The problem I have is - When I try to generate a form
from another oracle username the generate command fails. Is there
something I'm missing?
How can I store a form with common objects in the database and let
other users reference this form.

Thanks,

Rajasimha Aji
Newsgroups: comp.databases.oracle
From: irving@casbah.acns.nwu.edu (Thomas Myers)
Subject: Re: Help needed: Simple Forms V3 Qns.
Organization: Northwestern University, Evanston, Illinois, USA
Date: Tue, 12 Jan 1993 17:54:08 GMT

In <1993Jan12.083949.1@ocvaxc.cc.oberlin.edu> bamon@ocvaxc.cc.oberlin.edu writes:

>In article <1993Jan11.230248.8262@brt.deakin.edu.au>, ajmex@brt.deakin.edu.au writes:
>   DEFINE TRIGGER

>      NAME = POST-COMMIT
>      TRIGGER_TYPE = V3
>      DESCRIPTION = Post Commit
>      TEXT = <<<
>      declare
>       temp_command char(200);
>      begin
>        /* batch the program */
>        select
>            'batch/log=fa_log:fasj0630_BATCH.log' ||
>            '/noprint/keep/noidentify/noconfirm fasj0630' ||
>            '/param=("FASF0340","' ||
>            :form_variables.test_only_flag ||
>            '")'
>        into temp_command from dual;

There is no need use a select statement to accomplish this.  PL/SQL allows you
to simply 

temp_command := 'batch/log=fa_log:fasj0630_BATCH.log' ||
                '/noprint/keep/noidentify/noconfirm fasj0630' ||
                '/param=("FASF0340","' ||
                :form_variables.test_only_flag ||
                '")';

>        host(temp_command,NO_SCREEN);
>        message('Batched program FASJ0630.');
>      end;
>      >>>


>   ENDDEFINE TRIGGER
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: Importing files from LOTUS
Date: 5 Jan 93 09:37:50 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <31379@nntp_server.ems.cdc.com>, rsnyder@ems.cdc.com (Richard Snyder) writes:
> We have an application that requires data to be imported to Oracle 
> tables from a LOTUS spreadsheet.  I don't believe there is any
> Oracle utility to do this. However, I would like the benefit of others
> experience as to how to go about this. The following comes to mind:
> 
> 1) Are there any Oracle utilities to do the import written by 
>    Oracle, LOTUS or others?
> 2) If not what is the best approach to import the LOTUS data?
>    a) Write a script in LOTUS to do the import directly.
>    b) Put the LOTUS data into a flat file and then reformat the flat
>       file to an Oracle Import format.
>    c) Some other method.
> 
> Any information, ideas, experience will be helpful.
> 
>  Thanks,
>   
>  Richard Snyder
>  rsnyder@ems.cdc.com
> 
> Empros Systems International division of Ceridian Corp.
> 
> (612)553-4327
> 


	Easiest way to transfer data from Lotus to Oracle is to utilize an
intermediate flat file.  Simply select the columns desired in the Lotus
spreadsheet and print to a disk file.  Lotus will assign the automatic
extension of .PRN to the file.  

	Load into Oracle with the standard loader routine using the fixed
format style.  In my version 6.0 Utility manual this is shown as Case 2.

	One danger to watch out for.  If the last column in the original
Lotus spreadsheet is null, Lotus puts nothing in the output file.  When
oracle tries to read in the record, it will error when it attempts to read 
this missing column and reject the record.  Easiest way around this 
limitation is to create a dummy column at the extreme right side of the Lotus
sheet and then artificially place an entry in each occurance.  In this
fashion, Lotus will transfer the previous missing column as blanks rather 
than ignore it.  When you do the load into Oracle, just ignore the final
column.

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------


Newsgroups: comp.databases.oracle
From: dmend@ctp.com (Daniel J. Mendez)
Subject: Oracle DBA Utilities FTP Sites
Organization: Cambridge Technology Partners
Date: Mon, 11 Jan 1993 20:00:54 GMT


In article <1993Jan8.230350.4281@kakwa.ucs.ualberta.ca> you write:
>In  <31367@nntp_server.ems.cdc.com>  btreuman@ems.cdc.com (Bob Treumann) writes:
>> In article <479@ptt-iat>, roo@ptt-iat (? Roo) writes:
>> |> Hi,
>> |> I'm looking for ftp sites where I can find ORACLE stuff.
>> |> Especially I'm looking for DBA utilities.
>> |> Can anyone e-mail the addresses of some sites to me ?
>> |> Thanks in advance
>> |> Peter de Roo.
>>  
>>  
>> I would like to know this too.  
>>      

Can replies to this be posted instead of e-mailed, please? It seems that they
will be of general interest.  Thank you.

-- 
======================================================================
|Daniel J. Mendez   dmend@ctp.com | 
| Cambridge Technology Partners   |
| 304 Vassar St.                  |
| Cambridge, MA 02139             |
| Phone: (617)374-8397            |
From: 445362@llnl.gov (Grant Johnson)
Newsgroups: comp.databases.oracle
Subject: Re: Copy objects in Oracle froms 3.0
Date: 11 Jan 93 23:43:36 GMT
Reply-To: 445362@llnl.gov
Organization: Lawrence Livermore National Lab

Objects can only be copied from forms saved in the database.  Try saving the .inp and then copying...

---

Grant Johnson                                 Internet: grantj@llnl.gov
Lawrence Livermore National Lab	           PacBell Net: (510) 423-0406
From: p228@uni05.larc.nasa.gov (Bailey Bob)
Newsgroups: comp.databases.oracle
Subject: Re: SQL Net
Date: 8 Jan 1993 17:05:19 GMT
Organization: Unisys-Hampton VA
NNTP-Posting-Host: uni05.larc.nasa.gov

In article <1354@pivot-sts.sbi.com> ken@comanche.sbi.com (Ken Jones) writes:
>Dear Oracle Guru's
>
>We looking at using Oracle in a distributed environment. I've heard that
>this is accomplished using SQL net. But is it reliable? Is it a good product? 
>Is it worth it.  Are there any alternatives?
>
>I can post a summary to the net.
>
>Ken Jones

IMHO SQL*Net is a reliable product.  We are currently using it to share data
between 7 different database servers.  SQL*Net permits us to move/retrieve
data with relative ease.  If you are going to use Oracle in a distributed
environment, SQL*Net is the only option that I am aware of. (Unless you
want to export to a file, FTP the file to the other system, and import the
data; but this is a less than optimal solution.:-))  There are some limitations
to remote updates if you will be using Oracle V6.0, but V7.0 fully supports
remote updates (according to the info that I have read).  Remote updates are
possible with 6.0, but, the solution is somewhat of a kludge that we devised.

Bob Bailey
Paramax/Unisys
From: grant@reg.triumf.ca (Peter A. Grant)
Newsgroups: comp.databases.oracle
Subject: Submission contact for IOUW '93
Date: 11 Jan 1993 13:40 PST
Organization: TRIUMF: Tri-University Meson Facility
Distribution: world
NNTP-Posting-Host: reg.triumf.ca
News-Software: VAX/VMS VNEWS 1.41    


A couple of people have phoned me recently wanting to find out how they 
can obtain the necessary information to submit papers for IOUW '93.  I 
don't seem to have anything from last year near the top of any pile of 
paper next to me though.

If you know who is the appropriate contact, please pass it along to me so
that I can pass it along to our VOUG membership.  Thanks.

(We don't want to wait until the applications are mailed as in the past 
they have arrived weeks after the deadline.)


Peter Grant           ////////  ///////  ////////  //    //  //    //  ////////
grant@reg.triumf.ca     //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia

                  Chairperson, Vancouver Oracle Users Group

Newsgroups: comp.databases.oracle
From: prs9k@brain.med.virginia.edu (Phil Scarr)
Subject: Re: SQL Net
Organization: Neuroclinical Trials Center, University of Virginia
Date: Sat, 9 Jan 1993 12:25:48 GMT

In article <1993Jan8.225515.14297@digi.lonestar.org> mmittman@digi.lonestar.org (Michael Mittman) writes:
>
>My experience with SQL*Net is that it is a real dog when the darn
>thing is working.
>
>We have two databases on one machine (an Amdahl) which is partitioned to
>run UTS operating system (UNIX) and MVS operating system.  The failure
>rate for SQL*Net when going from UTS to MVS has been far to great, it
>fails at least twice per month (far to great for a large corperation). 
>
>Also, performance is a factor.  SQL*Net's transfer rate is about 512k.

Could you be more specific here?  512k per what unit of time?  Second,
Minute, Hour?

>
>Check out other possible solutions FIRST (ie: TCP/IP).

SQL*Net USES tcp/ip for its transfer in installations with a tcp/ip
network.  What are you using?  This might explain your slow transfer
rates.

>
>Good Luck
>
>Michael Mittman
>QRA Software Metrics - Software Tools Development

	-Phil
-- 
PHIL SCARR        \      We are Microsoft...     /          (o) 804.243.0229
 University of    /     OS/2 is irrelevant.      \          (f) 804.243.0290
 Virginia,        \     UNIX is irrelevant.      /        prs9k@Virginia.EDU
 Neurosurgery     /     Openness is futile.      \     prs9k@Virginia.BITNET
 HP-UX is my life!\ Prepare to be assimilated... /   ...uunet!virginia!prs9k
Newsgroups: comp.databases.oracle
From: hlam@bnr.ca (Hayward Lam)
Subject: NeXT User Group Of Ottawa on January 7th
Reply-To: hlam@bnr.ca (Hayward Lam)
Organization: Bell-Northern Research Ltd.
Date: Tue, 5 Jan 1993 20:18:00 GMT

NeXT User Group of Ottawa Meeting on January 7th
------------------------------------------------


When : Thursday, 7:00pm
Where: ComputerActive
       21 Antares Dr., Unit 112,
       Ottawa, Ontario, Canada


Topics: 
***  Database on NeXT  ***
Demo and discussion on databases and development tools 
available on NeXT.
Inlcude Parabase, Sybase, Oracle, DBkit, Objective DBtool kit etc.
Topic will be oriented for users and developers alike.
Demo machine is a NeXTcube with NeXTdimension board.

(A guest will talk about their experience with database 
development. Not confirmed yet.)


***  General discussion  ***
CD-ROM drive available for 3.0 upgrade.
Software packages discount for user group members.
NeXTWorld Expo etc.


Please pass the news around to whoever might be interested.
Feel free to contact me if you have any questions.


Regards,
Hayward

phone: 613-763-3663
email: hlam@bnr.ca
From: mickel@OES.ORST.EDU (Paul M. Mickel)
Newsgroups: comp.databases.oracle
Subject: Re: How to save the query from the form and re-use it later?
Date: 12 Jan 1993 05:50:08 GMT
Organization: Oregon Extension Service, Oregon State University, Corvallis, Or.
NNTP-Posting-Host: oes.orst.edu
Keywords: Oracle Form, Query by Form

In article <107@timer1.UUCP> john@timer1.UUCP (john) writes:
>Hello, World:
>
>We are implementing a form to access customer database. So, it is kind of
>basic like name, address, phone numbers and titles etc.
>
>Oracle Sql*Form 3.0 provides query by form (kind of nice). We would like to
>use this feature but we also want to save the query for future use because
>some queries can be so complicated and our users don't want to re-type it 
>over and over again. In addition to that, we also like to dump the results
>not only on the screen but also into a file so we can use it with mail
>merger of word processor.
>
>Is there any one out there who can give us a little guide, instruction or
>pointer on how to implement this mechanism ?

You can create a POST-QUERY trigger to do this, having the following body:

declare hoststr    char(256);

begin
  hoststr := 'echo "' || :system.last_query || '" > /tmp/filename_here';
  host(hoststr,NO_SCREEN);
  redisplay;
end;


The idea here is simple, take the last query entered, put the 'echo' string 
together (containing the :system.last_query), then use it in the 'host' 
function, which executes the 'echo' command and dumps the output to a file.
There are a couple of things to think about:

0. The :system.last_query stores the query used to populate the last block. 
   Hence, if you have a multi-block form, you will have to create/modify the
   triggers for these blocks to store the last_query from that block before
   moving on. If you have a master-detail relatoinship, you can do this 
   storage before executing the 'query_details' code (at least this was 
   given to us when we created forms w/ master-detail relationships).

1. Related to (0.), if you store the last_query in a global variable, you are
   restricted to 256 characters. This is a real pain in the neck if you are
   trying to pass this last_query to a report writer to do a query 
   dynamically (without knowing beforehand which fields get filled during
   'enter-query' mode). Our solution was to parse the 'where' clause from
   the last_query, store it in a global variable (and hope it still isn't 
   too long) and pass this to the report writer.


The example code is an adaptation of what I have written for work and is in
active use.  There may be better ways to do it, but this will work.

Hope that helps.

>Any help will be highly appreciated.
>
>
>John Y. Chan

-pmm

-- 
Paul M. Mickel			  	   Internet:mickel@oes.orst.edu
Sysadmin, Oregon Extension Service	   Corvallis, OR 97331
Database Programmer, Teledyne Wah Chang    Albany, OR 
Disclaimer: Neither employer has *ever* claimed any of my opinions.
Xref: sparky comp.databases.oracle:2769 comp.os.ms-windows.apps:6899
From: wwm@ef5003.efhd.ford.com (Bill Meahan)
Newsgroups: comp.databases.oracle,comp.os.ms-windows.apps
Subject: Re: Windows and Oracle access.
Date: 8 Jan 1993 01:50:33 GMT
Organization: Ford Motor Co., EFHD Ypsilanti Operations
NNTP-Posting-Host: ef5003.efhd.ford.com

In article <dtb.726316321@otto> dtb@otto (David Bath) writes:
>jessea@u013.me.vp.com (Jesse W. Asher) writes:
>
>>I remember a recent thread on accessing Oracle from MS Windows, but I
>>didn't pay any attention to it at the time.  Can someone bring me up to
>>date on the thread?  Is there a way to access Oracle from MS Windows?
>>Is there some sort of orasrv (SQL*NET) available for Windows??  Thanks.
>
>I have used and seen USERS use Q&E to access Oracle.  Q&E (without Oracle
                                                            ^^^^^^^^^^^^^^
>hooks) is distributed with Excel now, you just get the full version.
 ^^^^

Au contraire'  The Q+E distributed with Excel (late 3.0, 4.0 and 4.0a)
ALL support ORACLE access.  The "full" version from Pioneer Software is
much better, though.

>
>The nice thing is it does NOT attempt to fiddle with the SQL, just
>hands it over to Oracle (cf MS-Access)
>
>David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
>Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
>"Failure to emulate is the best revenge" - Marcus Aurelius
>-- 
>David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
>Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
>"Failure to emulate is the best revenge" - Marcus Aurelius


I have a couple of major applications using Excel as a "front-end" to
ORACLE databases residing on UNIX servers.  We have SQL*Net for TCP (DOS
version) installed on the PC and use Q+E (currently the version supplied
with Excel) as the intermediary.  An important key is to start up sqltcp
in your winstart.bat file so it is in Windows-managed memory space.

Works like a champ.

-- 
Bill Meahan			|EFHD Information Systems Staff
Plant Floor Systems Specialist	|Ford Motor Company
wwm@ef5003.efhd.ford.com      	| +1 313 487 6122
..!fmsrl7!pmsmam!wwm           |I'm not paid to speak for Ford!
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: Shutting down sqlnet
Keywords: sqlnet
Organization: Colonial Mutual Group 
Date: Sun, 10 Jan 1993 21:51:37 GMT


In article <1993Jan7.175023.13291@nsisrv.gsfc.nasa.gov>, you write:
> First of all, an apology for my question about shutting down oracle - I did
> not
> RTFM closely enough and missed the shutdown immediate command which I
> suspect
> is all I need.  Thanks to all who responded.
> 
> But I have a similar problem with orasrv and the manual does not indicate
> any type of shutdown immediate command.  I'm running on an SGI (IRIX 4) and
> when doing a tcpctl stop commmand I get back:
> 	tcputl: 1 subprocesses are active; server will not be stopped
> 
> This is listed in the sqlnet user's guide where it says that the action is
> to ask remote users to log off Oracle.  The problem is that we are doing the
> shutdown in the middle of the night in a batch mode and it is likely that
> the
> user just forgot to log off before going home.  Any work-arounds?

You can find out if there are any SQL*Net processes/connection by typing
'tcpctl
stat' and there will be a line saying how many connections there are 'Active
subprocesses'.  

You can also use the UNIX 'ps' command to count the number of connections. 
For
 ATT UNIX, type 'ps -ef | grep T:' and for Berkeley UNIX 'ps -ax|grep T:'.
This
also give the same info except that it gives you the process ID as well.   You
may then use the kill command to terminate the connection.

To actually find out which machine is connected to the databases is a bit more
difficult.  You will neet to use the 'netstat' command.

>  If this
> is being done as part of a reboot procedure, will it hurt to ignore this
> message and just reboot the system?
> 

No.
-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198
Xref: sparky comp.databases.oracle:2688 comp.os.ms-windows.apps:6679
From: jessea@u013.me.vp.com (Jesse W. Asher)
Newsgroups: comp.databases.oracle,comp.os.ms-windows.apps
Subject: Windows and Oracle access.
Date: 6 Jan 93 02:56:45 GMT
Organization: Varco-Pruden Buildings

I remember a recent thread on accessing Oracle from MS Windows, but I
didn't pay any attention to it at the time.  Can someone bring me up to
date on the thread?  Is there a way to access Oracle from MS Windows?
Is there some sort of orasrv (SQL*NET) available for Windows??  Thanks.

-- 
      Jesse W. Asher                                          (901)762-6000
                             Varco-Pruden Buildings
                 6000 Poplar Ave., Suite 400, Memphis, TN  38119
    Internet: jessea@vpbuild.vp.com                   UUCP: vpbuild!jessea
Newsgroups: comp.databases.oracle