I've been using two different distributions of the Developer tools.  One is
a distribution that has Forms 6.0 in it and the other is an Oracle 9i
distribution that has Forms 9i in it.
I'd like to load some data using SQL*Loader and do so on my PC, but neither

i have tryed to install Oracle 10g Enterprise Database (Release2) on a
clean Windows XP Prof. (SP2) maschine and on a Windows Server 2003. I
get the same errormessage on both PC.
The installation starts and work fine, but during the last steps (the

Hi Guru's
Desperately in need of your advice on this one. I am getting the
standard ORA-01031:
SQL> conn sys@preview.rtdb0 as sysdba

I have recently ugraded oracle 9.2.0.6 to 9.2.0.8  on HP-UX. I am
getting the following errors:
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded

Hopefully a  quick question but I have not been able to find out this
information.
I took my Oracle 10g Administration 1 exam about 2 months ago. On
passing this you acheive OCA (Oracle Certified Administrator) status.

How can I determine if SUPPLEMENTAL LOGGING as been enable at the
database level?
Done by this command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA  (PRIMARY KEY, UNIQUE,

Oracle 9.2.0.5. on Win2K3.
1. I loged in as user A and created a view my_view.
2. I loged in as user B and created a synonym for A.my_view.
3. Then I loged in as user A and granted Select on my_view to user B.

Oracle 9.2.0.5. on Win2K3.
1. I loged in as user A and created a view my_view.
2. I loged in as user B and created a synonym for A.my_view.
3. Then I loged in as user A and granted Select on my_view to user B.

Integration testing tool is available now. Integration testing in
which individual software modules are combined and tested as a group.
Help you a lot!!
http://top-itarticles.com/softtest/softtest022.asp

I am currently running Oracle 9i and unfortunately my STATSPACK tablespace
has filled 100%.  When collecting statistics now, I get the following error
in my alert log:
ORA-1653: unable to extend table PERFSTAT.STATS$SQLTEXT by 16 in tablespace

i currently have a shell script in which i am trying to pass a txt
file, by lines into a sql script. the txt file looks like this:
filename.ext :  category  PossiblyAnotherCategory
filename2.ext :  category  PossiblyAnotherCategory

Is there a way to recreate SYSAUX tablespace in 10g, This is requred
since I need to change extent size to smaller size to save space.
Without recreating tablespace changing extent is not possible. Is
there any work around to do the following.

a varchar2 column was stored with flip(value). I guess some sort of
simple encription. How can I reverse this to see it's actual value? I
tried flip again, but it did not work.
Thanks for any help or information.

Platform: Oracle 10.2.0.2.0 on HP-UX B.11.11
Posting to comp.unix.admin, comp.databases.oracle.server
A few weeks ago we began noticing that the .sh_history file for
'oracle' was being flooded with entries like this:

What is the most reliable way to check if the table changed?
I could take the rows number, but it could happen that some rows got
only updated, and the count of rows is the same, although table
changed.