Dropped tables from master 
Author Message
 Dropped tables from master

Hello there,

well, I dropped some tables in master:

spt_committab                  
spt_jdbc_table_types          
spt_mda                        
spt_jtext                      
spt_jdbc_conversion            
jdbc_function_escapes          

spt_values                    
spt_monitor                    
spt_datatype_info_ext          
spt_datatype_info              
spt_server_info  

I found out the last 5 tables can be recreated by installmaster script
which I have done already with good success.
Is there any way to recover the other ones as simple as that?
Michael



Sat, 20 Nov 2004 04:50:01 GMT
 Dropped tables from master

Quote:

> Hello there,

> well, I dropped some tables in master:

> spt_committab                  
> spt_jdbc_table_types          
> spt_mda                        
> spt_jtext                      
> spt_jdbc_conversion            
> jdbc_function_escapes          

> spt_values                    
> spt_monitor                    
> spt_datatype_info_ext          
> spt_datatype_info              
> spt_server_info  

> I found out the last 5 tables can be recreated by installmaster script
> which I have done already with good success.
> Is there any way to recover the other ones as simple as that?
> Michael

Yes, should be.  Try grepping for the table name among the various
install*
scripts (spt_committab is created by installcommit,
spt_jdbc_table_types
is created by installjconnect, etc) to find out which script has the
CREATE TABLE statement for the table in question.

-bret



Sat, 20 Nov 2004 12:17:03 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. dropped all tables in master dbase :-(

2. dropped all tables in master dbase :-(

3. Drop table versus truncate and drop index

4. Scripting DROP Table *and* DROP (related) Foreign Keys...

5. Problems dropping indexes when dropping tables

6. Relation between DROP TABLE and DROP INDEX

7. drop table failed to drop associated sequence

8. Dropping a DB that uses the Master device.

9. Oracle MM replication -- unable to drop non-master-def replication

10. Appending data from similar tables into a single master table!!!!!!!!1

11. Problem trying to Update master table from any DML on slave table


 
Powered by phpBB® Forum Software