Search:

Hi all,

I want to create a consolidated view in Oracle which provides data from two tables.

If the data is present in table A then it should not be fetched from table B.
this is the only...

Can any body pls help.

Hi all,

We have a stored procedure which transfers data between two tables once in a month. oracle version is 10g

Months data will be around 11Gb. But we have an UNDO segment of just 2Gb max....

Hi all,

We have an oracle database which is of 8i. We are planning to migrate to Oracle 10.2.0.3. I wanted to know; is it possible to migrate the entire schema(including all the tables, triggers,...

Hi all,

i have doubt on indexes.

suppose we have an index on a table. assume there are 100000 rows in the table.
now we delete those 100000 rows and insert a new set of rows.

Will there...

Hi Sir,

Another doubt here, Please throw some light on it,

suppose we have 10000 rows. and then after three months a old set of 10000 is deleted and new set of 10000 comes in, will the row ids...

Hi all,

I have doubt in rebuilding of indexes in oracle.

Please advice me in the following scenario.

i have a table which has indexes. the table data will be emptied once in 3 months. and a...