Hi Experts,
Please let me know if installation of Oracle 10g works well with Fedora 9.
I am doing installation of Oracle on Fedora Linux for first time, so please let me know if I have t...
Hi experts,
Can anyone suggest good books or links for Oracle reports Builder 10g.
I am trying to develop plsql code to generate automatic email to send as a reminder.I followed the procedure which was stated in the UTL_MAIL in the metalink about the UTL_MAIL.. But iam getti...
I've done some testing, so hopefully the next few lines will asssit in the solution.
I'm trying to install Oracle Express Edition 1og onto a vista laptop. I have attemted to install this o...
Hi, i have created a trigger that check for a value if it has duplicate values...it should abort a the operation that caused the tirigger. but it dont seem to work.
CREATE TRIGGER tg_pbaske...
Oracle Forms 10g...I have a master block with several detail blocks. When I enter query parameters directly into the master block and execute query (F7, enter criteria, F8), detail blocks pop...
I want to automate the AWR report generation.
There is a high loading period every monday from 9am to 1pm and I want that the AWR reports are generated automatically every monday for the pe...
My Oracle 10G temporary tablespace size is increasing abnormally.
it went to 33 GB in just 3 hours.
Why it is getting huge?
I have just installed Oracle 10.2.3 alongside a machibe that hosts 9.2.0.6. The oracle homes are on two separate mount points. I have created a new database on 10 and this is working ok. I hav...
Hello Forum members,
I am unable to run frmcmp on solaris.
Can you please advise me.
Thanks,
/u01/oracle/product/10.1.2/mid/bin $ ls frm*
frmbld frmbld.sh frmcmp frmcmp.sh frmcmp_batch ...
Hi,
We are using Oracle 10g. We have an SP that returns a ref cursor with a CLOB column in it. The issue that we face is that whenever the data in the CLOB column exceeds 4000 chars, the co...
i want to generate Excel output from oracle Reports. Seems oracle Doesn't support Excel reports. Is there any way to achieve this functionality?
We are running the below script every week.
We are not rebuilding Indexes every week.
Is it a good Idea to rebuild Indexes every week or periodically.(All the indexes in the database)
We ha...
Hi Experts,
I am working on a class assignment for Oracle SQL Plus. Part of the assignment is to create two tables using a script file. One of the tables "departments" only has 27 records s...
I've been reading some answers to the question "How do I select all columns from a given table, but exclude certain ones?". It appears that, outside of SQL*Plus, there is no way to do this. My...
Is it a way to import/export only roles and users,? I need a script that would allow to generate roles and users with all the existing privelegies and import to a new Oracle instance
I have this in my control file for sqlldr to oracle and it works fine:
LOAD DATA
INFILE 'C:\Inetpub\wwwroot\ESS_Web_Analysis\essuser\push\errorsout.dat'
REPLACE ...
non-killable session
Enterprise manager Finding: Wait class "User I/O" was consuming significant database time.
After invesigation, a session has been consitantly consuming 25% CPU on o...
Hi Experts,
I have installed Oracle 10.1.0.2.0 on Solaris 10 (SPARC). As soon as i have installed Oracle, i have applied Oracle 10.1.0.5.0 patch. Now when i try to connect the the database ...
I'm loading a flat file with fixed-width fields into an 'external table' containing clobs. The file comes from a Unix environment and the db I'm loading it in is Oracle 10g on Windows (newline...
Hi,
OS: Win XP
Oracle 10g Release 2
I have successfully created the repository for Database but when i run command given below it gives error:
E:\oracle\BIN>emca -config dbcontrol db ...
I'm participating in a oracle upgrade project (from 9i to 10g)
There are some objects which are valid in 9i but are invalid in 10g.
when I try to "desc" these objects, some of them return ...
I am trying to create a trigger that works after the insert of a record on one table; then goes to another table grabs data for the matching key column and inserts it into a 3rd table to creat...
I have little batch file that reads the files in a folder and loads them into oracle table using a static ctl file. But I have field that stores the name of the data file from which it was lo...
HI ALL
i have oracle 10g database i want to change the database name ,guide me
thanks
