Re: Need to restore from dump

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Wed, 10 Apr 2002 21:37:51 GMT
Message-ID: <3CB4B0AE.C68A18B6@exesolutions.com>

As I understand it his issue is not restoring with an import ... but rather than the table structure has been changed.

Personally I'd change it back. Import the data. And then do my alter table DDL. Daniel Morgan

Sybrand Bakker wrote:

> "Pinaki" <bpinaki123_at_indiatimes.com> wrote in message
> news:96eccafc.0204101016.e6384c4_at_posting.google.com...
> > Hi,
> >
> > I have the dump of the data created through the export utility.Now I
> > have changed the structure of a particular table in the
> > database(actually added a column) after having deleted the data of the
> > particular table.Is there any way I can load the data back into the
> > table from the dump.will sqlLoader be able perform the job...
> >
> > Thanks
> > Pinaki
>
> Tables being exported can be restored by running an import
> Please refer to the chapter on import in the Oracle utilities manual.
>
> Regards
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
Received on Wed Apr 10 2002 - 16:37:51 CDT