Need to insert more than 4000 of data into an Oracle Clob column. I notice the size on the clob column is 4000 by default. I'm using Oracle 9i.
We are using .net/c#. How do we insert more ...
I have about 5 tables, and they have have FK constraints on a main parent table. When I delete from the parent table it can take up to 6 minutes for the query to complete. All FK's have inde...
hi i am witing small proc in orlace to write some of rows of table a file, the i am facing is not the command dbms.output.put_line fails after 255 chars. hence suiting problem can any suggest ...
Windows Vista Ultimate could not start the Oracle Listener on Local Computer
Error 1067: The process terminated unexpectedly
Hi guys -
One of my table columns in an oracle database is a clob datatype and actually contains xml data.
I need to write a query to find out all the rows that contain "$nbsp;" in th...
Hi All,
I have a question regarding how to delete rows.Here is the question:
1.I have a table with around 11,000 rows.
2.Table sql statement is :
CREATE TABLE M_10
( ID1 NUMBER(6,0...
I use Oracle Reports and every time I try to run the reports, I get this error:
REP-51002: Bind to Reports Server [servername] failed
Oracle 9i is being used on HP-UX. I have read so...
I have Timestamp field in my Oracle table. I need to get difference between SYSDATE and Timestamp field in exact number of seconds. Any idea how it can be achieved.
I am developing oracle forms, in that i have given a data block item as required. when the user doesn't enter the value it just shows an error message. I want an alert statement for that, for ...
I have two tables, parent/child (1-m). I need to track all changes made to either table and maintain the relationships at the same time so I can capture an audit trail and also a snapshot at a...
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...
Hi,
I have to create two table spaces with BLOCKSIZE 16384 and 32768
When I executed the create table space statements I got the following errors:
1. ORA-29339: tablespace block size ...
Well, I finally need to bite the bullet and upgrade my clients from 8i to 10g. Is there anyone that can give me some tips as to what problems I may run across?
When I try to get an explain plan of any sql statements (even like select sysdate from dual;) I am getting error:
Explain Plan Error: ORA-01775: looping chain of synonyms
In the given da...
Export terminated successfully with warnings.
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number # with name "" too small
Despite the warning ab...
I have an application that is using Access 97 as the interface and using VB and Microsoft ODBC driver to connect to an Oracle database via DNS machine that is in a different location. I 'm l...
Hello, I have an oracle instance named CORPOR.
I need to get a listing of all schemas, the tables underneath it and their columns as a listing. Can you please help me generate a SQL for this?...
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...
Experts ,
i need export data from one db to another db. i have a table with 35 partitions. now my intention is to export data from based on query and partition wise. can any one help me to ...
I have two tables with relatively disparet information. I want to join these two tables together to form a sequence of events. This hould be easy, but I can't seem to get the query right.
...
A couple of weeks ago we installed the Oracle client software on our development IIS box so that we can connect a legacy ASP application to a remote development oracle database server. An ODB...
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 ?
I ave a relatively large database that had some minor performance issues. I had been going through and Analyzing tables and computing statistics. This improved overall efficiency and the num...
I want to query the table to get back the maximum value (in this instance, the most recent date) from each row. Please see attached for sample data (fig 1) and desired output (fig. 2)
I cou...
I have the following query which i am trying to execute, but throws an error. I used 2 single quotes so that i can have 'Stop' in the database. Not sure what is causing the error is it the for...
