I have to use a computer with 9i client installed, but I'm connecting to a 10g database. I'm trying to use Oracle Enterprise Manager Console. (I don't need the all the features that 10g woul...
I am using SQL*Loader to load files that are in CSV format. I want to set commit points for the load process. How do I tell SQL*Loader to do a COMMIT to the database every 1000 rows inserted?
Hi,
Using Oracle 9.2.0.3, I receive the following error : EXP-00056: ORACLE error 4068 encountered
when exporting from Enterprise Manager console...I?ve searched on the web for a solution...
I am producing two parameters from a webpage (jsp,java) and am sending them to a shell script.
I want to call them in a stored procedure from the shell script as below:
s...
Hello!
I have a column which have time and date in it. assume now() function in VB.
It is like this:
2007/07/28 06:54:41
It have about 10000 records with a column called last which h...
Hi,
Im trying to clone a database using RMAN DUPLICATE command. I have gone through the documents and was able to get a basic idea of how to do it. Im still suspicious whether i got the...
hello expert,
I have oracle 9i load on windows 2000 wortstaion
i using spfile as my initializtion parameter file
how can i switch from noarchivelog mode to archivelog mode
How can one analyze the information generated in bdump tracefiles ?
Hi,
Is anyone can help to find a good tutorials (video, books, web sites and e-courses) for the latest version of Erwin (r7? preferable)?
Thanks.
Hi experts, how i do to learn RMAN of ORACLE for backup and recovery system. i need the sintax script. Thanks a lot.
Hi,
We are using Oracle 9i database and forms and reports 6i as front end for our softwares
this is working fine with windows xp, but when I try to install the same in windows vista I am not...
If I had a corrupt redo log and restored an old redo log from 5 hours prior to the corruption and ran RECOVER DATABASE USING BACKUP CONTROLFILE "filename", will the database be point in time....
hi experts
I'm new in oracle 9i i would like to create a new schema to be viewed as "sys schema" under the database
How could i do taht ?
thanks for your help
Hello,
Can an Oracle pl/sql expert help me construct a left outer join in Oracle 9i that excludes some values in the join table?
Example:
Select a.emp, b.manager from emp a, manager b
...
I "inherited" forms 6i application from other developer who no longer with the company. He developed application using "form reference" method, meaning that instead of pll library he was using...
I am getting the below error when I was trying to bring one of data files back to online
ORA-01113:file 12 needs media recovery
ORa-01110 data file 12: C:\Ora92\oradata\oracle9\example3.dbf
...
I am trying to change a MS SQL query so I can use it in Oracle, i am new to Oracle and dont know where to start - can someone help convert the query to Oracle
hi
i have a table with 5 partitions.
now i want something like this.
select * from table_name (from partition 3).
how to do this ?
Hi,
Can anyone send me a query which will give me the total size of my oracle database and the space utilzed till date in my oracle database
Cheers,
Suhin
SP2-0332: Cannot create spool file
I get this error when I run my unix script. I spool to /opt/logs/exception_file and it gives me error SP2-0332:. when I spool just to the file name excepti...
Oracle v 9.2 on Linux
I created the following MV (300 million rows, 33 partitions)
It is partitioned on wk_idnt a partition consists of 4 weeks. I took the indexes from the detailed tables a...
I am trying to install oracle 9.2.0.8 on an oracle 9i client installation. How would I go about doing that? I have multiple ORACLE_HOMES (9i client and 10G database).
Hi Folks,
I have a table cnam_load which is Oracle table and the columns of the table are :-
mdn
action_type
I have to use the over partition by command to get the first value and th...
SELECT * FROM
TABLE1 a
INNER JOIN TABLE2 b ON (a.KEY_ID=b.KEY_ID)
doesnt this work on 8i???
what could be easy solution?..i know the option of writing a,b where a.key_id=b.key_id..
...
i just need to add a date condition in where clause of my select statement can some one help here i am new to oracle.
here is what i need...
WHERE log_date between (sysdate-2) and (sysdate) ...
