Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dumb question- can you backup only data from tables? DBA sez no

Re: dumb question- can you backup only data from tables? DBA sez no

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Thu, 11 Mar 2004 11:33:20 -0500
Message-ID: <qx04c.42856$lT6.221410@news20.bellglobal.com>

"Syltrem" <syltremzulu_at_videotron.ca> a écrit dans le message de news:y204c.986$Xy3.3688_at_tor-nn1.netcom.ca...
> "Bib Endum" <gd-newsgroups_at_spamex.com> a écrit dans le message de
> news:gK%3c.42576$lT6.218546_at_news20.bellglobal.com...
> > In your case, it looks like your application probably has no referential
> > integrity built in and the data is messed up in some way. Many 3rd party
> > apps generated with stuff like uniface do not implement native
referential
> > integrity because they are portable accross databases. This generally
> lends
> > to poor performing code, and to integrity problem.
> >
> > I suspsect that is what you have.
> >
> >
>
> If the OP re-loaded all the data from the original db, to the new db he
> created from the application's setup script, I don't see referential
> integrity as the problem.
>
> --

As I understand it, the OP tried reloading with import, then still got error, and then manually re-entered all the data, which took 2 hours and no longer had any problem. He was just asking why he had to manually re enter the data. Received on Thu Mar 11 2004 - 10:33:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US