This is more about the recovery aspect. I have a database in archivelog mode
and we are doing hot backups. Is it possible to do a restore without a cold
backup as a baseline? Assume you do hotbackups every night, and you keep 2
weeks worth of backups. Additionally, you backup all ...

                                                            OMNI GROUP
                                                 tgugger@buckeye-express.com
                                                            419-380-8853
                   FULL TIME PERMANENT SALARIED ORACLE ...

Oracle8i/9i.
Is it possible to identify sessions that have tracing turned on from
the Data Dictionary views/internal tables?
I found a discussion in Metalink that shows the events that are set.

I have ...
Oracle 10.1.0.2.0 on Solaris 64bits
sqlnet.ora > SQLNET.AUTHENTICATION_SERVICES= (NTS)
sqlnet.ora > NAMES.DIRECTORY_PATH= (TNSNAMES)

because I never did an exp/imp between Windows and Linux, I would like
to ask you wether it is possible to do an export on Windows, ftp or
scp the file to a Linux- Server and import it there into the Oracle
Database. Versions of the DB are both 9iR2.

I am student of Computer Applications Vth semester.
I am learning ORACLE for the first time.
I wanna practice Oracle Database Admin. tasks but I have only a single
computer system. So which version of ORACLE should I use and also which

Hey Guys, I've just got to tell you about spam filtering of the
newsgroups at Google, if you don't already know.
I read NNTP news from a feed provided by my ISP. I just noticed yet
more "OMLET" spam coming through on this feed. You know the stuff

Can we use ORDER BY clause in view's definition:
CREATE OR REPLACE VIEW a_v as
select * from a order by 1;
According to Oracle's Student Guide, this is not allowed.  But, by my

Am relatively new to Oracle,
Is there a way to display the speed of queries - how long it took?
Useful for testing/comparing efficiency
regards

We're experiencing a quite strange problem with our Oracle 9ir2 for Windows.
Suddenly, without having changed anything about its configuration, we cannot
longer connect to it locally with the Enterprise Manager or SQL+ because it
always raises a ORA-12699 error. But we actually are ...

I have a shared library written in Pro*C (no OCI) for Solaris.  The
client program first calls a function in the library to connect to the
database, then calls additional functions to get the information it
needs.

Hello FRIENDS,
I have successfully installed ORACLE 9i on Windows XP operating system.
I wanna know that how can I transfer my databases created in Microsoft
Access 2003 to ORACLE 9i.

My Oracle 9i db table structure is:
Members (sysid(PK), classid, personalid, firstname, surname,
dateofbirth, deleted)
Education (qualificationid(PK), personalid(FK), qualificationtype,

I have a complex query that I hope I can explain it well enough for
everyone to understand.
 I have a table that contains information for work instructions.
Contained in the table are "MACHINE_PROC" these are groupings of

Oracle 9.2.0.6 on Linux ....
I have a table, a log over time of the status of clients in client sets
resembling the following:
s_date       e_date     c_set  c_id  stts