Re: table partitions

Hi

You first should load the data to an ordinary table without partitions. After the data is checked convert the table into a partition of the main table.
It is a very fast command , because no data is moved , only data dictionary is modified.

(ALTER TABLE main EXCHANGE ....)

regards

Kari

(Mr.) Kari Pannila

      Oracle DBA

--

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.

Mujahid Hamid wrote:



> Hello all,

>

> I have a table with 48 partitions, I load data into one partition every

> month. table is partion by range on load_date column.

>

> I want to be able to do the following:

>

> (1) Stop users access to the partition that I am loading

> (2) After the successful load, the data have to checked by one user and

> while this data is being checked

>      the other users should not be allowed to access this partition,

> (3) after the data has been checked then allow all the users to see this

> partition

>

> Is some or all of the above possible or I am asking for too much here.

>

> Please help

>

> With Thanks

>

> Mujahid


--
Kari

(Mr.) Kari Pannila
      Oracle DBA
--

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.