home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,309 of 2,288   
   .com to bbcrock@hotmail.com   
   Re: Dumb story short- need to recreate f   
   19 Apr 04 15:59:58   
   
   From: mcstockX@Xenquery   
      
   "D"  wrote in message   
   news:22e171df.0404191145.291b4a51@posting.google.com...   
   | Database 1 is corrupted.  Database 2 was created by dba but none of   
   | the primary or foreign key constraints were ported over.  TOAD won't   
   | let me export.  I will try ErWin next.  What is the best way to   
   | recover this information if the views are corrupted and through   
   | errors?   
   |   
   | thanks,   
   |   
   | Lowly developer   
      
   sad story, but a few more details would help...   
      
   database versions?   
   how did the DBA create database 2? is there an EXP file? was it take at the   
   system, user, or table level? does it contain any constraints or unique   
   indexes?   
   can database 1 be opened?   
   can data dictionary views be read?   
   can sys tables be read if the data dictionary views cannot be?   
   how many schemas are involved?   
   which schemas cannot have object definitions read from the data dictionary?   
   is your resume up to date?   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca