Database hangs

[NITIN27]

Hi

I Have issued a command to database through sqlplus command is
Alter table branch drop(&column_name) checkpoint 10;

There are atleast 20 columns are in this script
This commmand is running for more than a day and it has also lock the branch table.I am not able to view the records from the Branch table could Anyone tell me possible threats and remedies to solve this problem I am new to Oracle database so Pls also tell me the Syntax too.

Merry Christmas

 

[sem]

Can you explain the aim of your checkpointing after each 10 rows??? Do you think that 1000 at least may run out of RBS?

Regards, Dima

http://seminihin.narod.ru

 

[NITIN27]

Actually I didn't have enough idea about it But i Just know that now my table is in invalid or ORA-12986 my columns are in partially dropped state and when i query from branch table then system ask me to write a command

"alter table branch drop columns continue;"

i have done this but database again hangs and all the tables which are using branch table get locked and doesn't show anything

so now what should i do and also pls tell me what checkpoint command is and when it is used

Thanks in Advance

 

[sem]

When checkpoint occurs all modified database buffers are written to the datafiles. Thus you force writing to datafiles after each 10 records.

... drop columns continue

is the only command you can run on that table. So you may either wait for finishing that command or restore your database untill the time you've started your script and launch it again whith more reasonable numbers.

In general it's a good idea to read about command BEFORE running it



Regards, Dima

http://seminihin.narod.ru