hello JH,
important:
* Check what indexes exist on the table
- Check the grants on the table (dba_ or All_tab_privs)
- Check if there's a trigger on the table.
- Check for constraints
The functions, procedures, packages will all recompile and work
if you checked all this. Use Toad (create script option) or
something like this:
select owner,name
,lower(decode(type
,'PACKAGE BODY','pkg body'
,'TRIGGER','<b>TRIGGER'
,type) )
,referenced_owner
,referenced_name
,lower(decode(referenced_type
,'PACKAGE BODY','pkg body'
,'NON-EXISTENT','non-exst'
,referenced_type))
from DBA_DEPENDENCIES
where referenced_name = upper ('&&table')
order by name,type,referenced_type,referenced_owner
/
select c.constraint_name "constraint",
decode(c.constraint_type,'P','Primary Key',
'U','Unique Key',
'C','Check',
'R','Foreign Key',
c.constraint_type) "type",
c.r_owner "REFtable",
c.r_constraint_name "ref constraint"
from ALL_CONSTRAINTS C
where c.table_name = upper('&&table')
and c.owner = upper('&&owner')
/
select grantee,owner,table_name,privilege,GRANTABLE
from DBA_TAB_PRIVS
where owner = upper('&&owner')
and table_name = upper('&&table')
/
jh <jhaisu_at_yahoo.com> schreef in berichtnieuws
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 - 04:50:25 CST
