We have a brand new 2 CPU Sun V480, with a brand new StorEdge 3310,
containing 12 72 G drives.
Thanks to this group, I found the Oracle S.A.M.E. paper, and I'd like to try
it.  Our main database has over 1000 tables, and similar # of stored

I am in a crunch and need to covert this Oracle statement to MSSQL. Is
there any Oracle/MSSQL experts out there that can help me? I do not
understand the syntax enough to modify this.
Thanks so much for any assistance. Here is the procedure.

I am testing Ocopy for the purpose of backing up our Oracle database and
 I'm confused by something.  When I make some test entries into a
table, the Oracle data files appear to be unchanged.  I assumed that the
data would eventually flush into the data files, after a few hours ...

i had a basic question on plsql, if i have a variable as varchar2,
containing some text like 'A12345', how do i write a function to make
sure that the first char. is the letter 'A' or 'a' and the next five
characters are numbers?  sorry about asking a basic question, but i'm

which oracle background process triggers the "alter system switch
logfile" as per the init.ora parameter "archive_lag_target"?
Not sure if its LGWR or ARCn?
Thanks

I want to know how to access Oracle DB under Solaris System.
I could access the Oracle DB with system administrator permission under
windows 2000 where the oracle is installed.
however, I cannot user sqlplus + username to access my oracle DB as

I have recently complited B.Sc in CS.
I have offered a job named 'Junior DBO(database operator)'.
I am really cofused ; should I accept the job .
As I am a B.Sc is it lower position to my education level ?

Please ignore this if the questions of amatuers are not allowed here.
I thought that perhaps the rare hardware configuration might be of
interest, however.
Thanks in advance.

Here's one for you experts:
I have a 9i release 2 db set up, to which I connect via the JDBC thin
driver.  I have a JavaServer Pages application that needs to read a VARRAY
from a table and then use the contents of the VARRAY.  Here's the code in

Does anyone know how many simultanious local connections Oracle 9
Pers. Ed. can handle.  I know it is limited to the local user and
"can" have unlimited connections.  But, how many can it handle
reasonably?  Thanks for any info you can give me!

could any body send me the inventory databse tables with comments and relations

I need to copy a table from an 8i oracle database to a sqlserver 2000 database.
Is it possible to use the command "COPY FROM ... TO ..." ?
So,  what is the correct syntax ?
Thanks for your help

key columns from user_part_key_columns:
44    SUMMARY    TABLE          SERVICE_DATE    2
43    SUMMARY    TABLE          SERVCLASS_CODE    1
existing partitions:

Does anyone can explain this to me :
I have table "T1" with 300.000 rows, one index on field "F1"
and rows are not inserted in sequence order (F1 : first inserted  "000002",
second inserted "000003", then "000008", "000001", "000004",... => I need

 this rather looks like a SQL question but I am in an Oracle setup, so if
there is an Oracle-specific solution to that I wouldn't mind, that's why I
am posting here.
 I need to select from a table and perform some complicated operations of