Re: External Tables

On Jul 30, 8:14 am, The Magnet <a...@xxxxxxxx> wrote:
On Jul 30, 1:02 am, sybra...@xxxxxxxxx wrote:





On Wed, 29 Jul 2009 19:12:21 -0700 (PDT), The Magnet <a...@xxxxxxxx>
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
.

Relevant Pages

  • Re: recover data
    ... You can not import database files into an existing database. ... Best you can do is to recreate the controlfile from the files you were ... Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: Disk full from delete
    ... The problem is that this is a script we will be using over the next 6 months and foreign keys can change and the names of the foreign keys could change if someone drops it and re-adds on the customer side. ... I actually move the database to a test database first and run the scripts and fix anything that may have changed and when it works clean I run it on the actual database. ... You could manually maintain separate scripts that drop and recreate the foreign keys/constraints as the database changes are applied. ...
    (microsoft.public.sqlserver.server)
  • Re: [Info-Ingres] User Creation File
    ... Don't forget database privileges, ... Record Database Information ... for iidbdb created in Step 1 of the upgrade procedure. ... A file called users.sql is written that will recreate all users, ...
    (comp.databases.ingres)
  • [NEWS] Granite Software ZMerge Administration Database Insecure Default ACLs
    ... the ZMerge administration database grants ... Note that while anonymous web users can read and modify all scripts, ... The ZMerge administration database contains the data import/export scripts ... server, allowing scripts to read and write arbitrary files on the server. ...
    (Securiteam)
  • I am available now
    ... Data Models, Data warehouse design, Data migration, Data population, ... Database consolidation, User Interface Prototypes, Database design, ... Oracle Workflow - Business Process Management Solution. ... To collect database and application related data, set of scripts have ...
    (misc.immigration.usa)