I am interested in knowing how to delete millions of records
periodically from a table efficiently.
Can we use the nologging option on the table?
I am NOT looking for solutions which copy the records across a

what's wrong in the following pl/sql code
DECLARE
va VARCHAR2(10)
vb VRACHAR2(10)

Please could anyone advise on the best way of ensuring an object stays
within memory.
I have a situation where frequent full table scans are being executed
on the same table

I have a table that has 2 columns,ColID--ID Column and text column.
The ColID Column is the
Primary Key for the table. I want to insert only text values in this
table. I do not have ColID values, but want to insert numbers in

hello Gurus, i have a clarification. is there any scripts or tool to
extract only the structure and schemas without the data of an existing
database, and use the same for creating a new one. thanks in advance.

We currently use Enterprise Manager 9.2 to monitor Oracle 8.0.5, 8i and 9i
databases. This runs on a dedicated management server. The problem is that
EM 9.2 can not monitor 10g databases.
Questions :

Hi, all.
We're moving from 8i to 10g via an export/import path.
In a test process, we exported all non-system schemas into a single
.dmp file. This was a DEV database, so the export file was about 1GB.

- Hi
Ideally I would love to use variables defined and assigned inside a
view.
create or replace view as rates

I have a table called GM_PRC with the following data:
SKU_NUM        ITM_CD     BEG_DT        RET_PRC
-----------    --------    ---------    --------
000000898-01   000000898  2003-12-03    56.99

Hi Friends,
We are a consultancy and we are having the following openings with us
------------------------------------------------------------------------------------------------------
1)

 which is better from 'best practise' perspective:
declare
  cursor ...
begin

can i get clear details about PRAGMA EXCEPTIO_INI
Sent via Archivaty.com

        i am doing programming at my home for my own.i want to open my
account on Oracle site.But it is asking me company name & email id for
some ORACLE OPN PIN NUMBER . As i am new member of this group, will
anybody  help me regarding to this topic?

Ok I'm cheap, but when I'm online I'd like to use my time wisely. Could
someone point me to some good intro to Oracle sites.
Thanks
Steve

I was hasty and I did a cold backup incorrectly, I believe.   I shut
the database down and backed up only the data files for one (out of 4
tablespaces).   I started Oracle and proceeded to work on all 4
tablespaces.  Today I needed to quickly roll back the tablespace I