Re: Import in a precreated schema: triggers and foreign keys question

From: G Dahler <gordon.dahler_at_spamex.com>
Date: Fri, 22 Oct 2004 09:26:50 -0400
Message-ID: <tU7ed.58295$JG5.962230@news20.bellglobal.com>

"Brian Dick" <bdick_at_cox.net> a écrit dans le message de news:1gv5avq1897hu$.1p7t4mc7hffzp.dlg_at_40tude.net...
> On Thu, 21 Oct 2004 13:39:15 -0400, G Dalher wrote:
>
> > Oracle 8174
> >
> > I want to export a schema in order to rebuild it's segments in a locally
> > managed tablespace (autoallocate)
>
> alter table X move ...

Nope. This works great for a small number of simple tables, but when there is intermedia stuff involved, it becomes a mess. In my case, what I have to move is an oracle designer repository + some application data. Lots of tables + indexes Received on Fri Oct 22 2004 - 08:26:50 CDT