Re: External Tables

From: ddf <oratune_at_msn.com>
Date: Thu, 30 Jul 2009 06:30:51 -0700 (PDT)
Message-ID: <5e2eaf35-8178-45ef-91f0-69404b1ad4bb_at_26g2000yqk.googlegroups.com>

On Jul 30, 8:14 am, The Magnet <a..._at_unsu.com> wrote:
> On Jul 30, 1:02 am, sybra..._at_hccnet.nl wrote:
>
>
>
>
>
> > On Wed, 29 Jul 2009 19:12:21 -0700 (PDT), The Magnet <a..._at_unsu.com>
> > wrote:
>
> > >Hi,
>
> > >When you export a schema, are external tables and directory
> > >definitions exported also?  So, when I import, it will create the
> > >directory definition and the external table?
>
> > Did you try?
>
> > -----------
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Did try and did not get it to work.  So, thought there might be some
> convoluted way of doing it.  I mean, if a company has 300 external
> table definitions, it would be meaningless if  you cannot re-import
> those definitions.....and have to re-create those tables again...- Hide quoted text -
>
> - Show quoted text -

External tables are built upon flat files and neither exp nor expdp export such files. Exporting the definitions, then, would be a useless undertaking. This is why one uses scripts to create such objects, so they can be recreated in another database (or in this same database) provided the source files exist. It should not be a major effort to run a series of scripts to recreate such tables.

David Fitzjarrell Received on Thu Jul 30 2009 - 08:30:51 CDT