Hi experts -
What is the syntax for sqlloader for Fixed length data. do we need to specify fields terminated by?
LOAD DATA
INFILE 'c:\temp\xxx.d...
hello,
can anybody tell me how to configure application express 3.2 with 11g database, without using the embedded pl/sql gateway.
Thank you.
Hi
We did strms setup But I few question.
How can we determine what are archive logs that are need by capture process?
How can we find archive logs that are already captured?
Is there ...
I need to compare all the objects of Production to Develpment. So I need reports something like.
Schema Type of Objects Number
HR Ta...
The automatic statistics collection is scheduled in our Oracle 10g databases with the default parameters. This means they start during the week at 10 PM and will run within the 8 hour timefra...
we are framing the DR plan for our organization, i just want to understand the concept of disaster recoyver and recovery metrics
regards
vinod
foks
how do I run a script to view all the configuration settings of an existing database? ie language settings etc, I eed to export this database to another environment and would like to k...
Experts,
Is it possible to add new table to existing table level streams replication group? If answers is YES, please let me know.
Thanks.
how to determine if the enviornment is a RAC env in oracle ?
How do you synch windows vista calendar to ipod
Hi,
I've function "execute_sync_query".
I'd like send mail after update when pAfmTab in ('RACK' or 'EQ_OUT') with where condition in update statement.
I create stored procedure: "SEND_NOTIF...
Discoverer reports which normally run in 15 minutes are running for more than 2-3 hours
The discoverer is fine,up and running,there are no locks in the database,In addition trace has been put...
Hi All,
I need your technical guidance related to Urdu Support in Oracle Forms & Reports 9i.
Below are the details of requirement and R&D effort we made to achieve the desired output:
...
Everytime I recompile objects my webservices gets : ORA-06508: PL/SQL: could not find program unit being called.
Tomcat restarts solves the problem and I do not know why that is ? It was not ...
i have one requirement.just assume that the data is like this.i need to bring the salary with comma separated values like(1000,3000,1200) by grouping doc_no;
doc_no salary
A1 100...
Hello, I am working with a new Oracle Database feature that support for text predicates in rule conditions. Please I need some examples abou it. Thanks.
Regards.
My SQL Developer Version is 1.5.4
Here is the Oracle Server Versions.
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
...
" Your average wait time for db file sequential read is 8 milliseconds, which is very slow. The sequential read event occurs when Oracle reads single blocks of a table or index. Index reads or...
Hi
An Oracle Forms question :
I have got a multi record block with an unbound item (button). When I press the button, the record pointer cannot jump to the button's line. So I don't know t...
How to defragment an oracle 9i database of about 1.5T
Hi,
I've this table T_MONTH_COST
COD_ID...........X_YEAR........X_MONTH........SUM_COST
22...............2009............01..........2000
33...............2009............02..........500...
