Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data corruption
Do you know why you have data corruption in the 1 table?
That would bother me the most. Try doing a full export and you may find more tables. If you do, seems you could have some disk problems too ?
Anyway, just a thought.
"jh" <jhaisu_at_yahoo.com> wrote in message
news:b0833k$olh$1_at_bob.news.rcn.net...
> Hi all,
>
> I am having a problem with the database. Oracle 8.0.5, NT4.0. There are
> data corruption in a table. I plan to recreate the table using CREATE
> TABLE new_table AS SELECT * FROM original_table... filtering out the row
> that has the problem. When I rename original_table to dump_table and
rename
> new_table to original_table, how can i make sure the functions, procedures
> synoyms, and objects for the old original_table are associated with the
new
> original_table. i.e. will the functions and procedures validate for the
new
> original_table? Is there anything else I need to watch out for?
>
> Any help is appreciated.
> Thanks.
>
> jh
>
>
Received on Sat Jan 18 2003 - 01:37:19 CST