Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Working with 2 schemas
Hi Pawe,
No, because there is no reason to do so.
When importing, if you don't want Oracle to recreate the table (presumably because the table already exists), simply specify IGNORE=Y.
Cheers
Richard
"Paweł" wrote:
>
> Is there an option in export to export only data without table definition?
>
> Pawel
>
> > If you are looking at two different databases then try export and import
> as
> > a quick/well documented route (see the Oracle Utilities manual).
> >
> > Andy
> >
> > "SK" <birdieng_at_yahoo.com> wrote in message
> > news:9a5c8521.0208050226.f22c280_at_posting.google.com...
> > > I need to insert records from one schema to another, but I'm
> > > restrained from using DB link. Can anyone suggest alternatives?
> > > Many thanks in advance.
> >
> >