Discussion :

[jadey]

Hello les gens,
Il me semble avoir lu une fois sur la doc que la création d'une table externe au travers d'un

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

CREATE IMMEDIATE

était sujet à certaines restrictions notament au niveau du fichier plat (je ne me souviens plus si c'est en terme de taille ou de nombre de lignes) j'ai besoin de cette information, mais n'arrive plus à la retrouver.
Merci pour toutes vos contributions.

[fatsora]

B'jour,

P'et ceci

http://www.rampant-books.com/art_more_ext_tables.htm

Notamment
Limitations

External tables in Oracle9i have the following limitations:

* They're read-only, so no data manipulation language (DML) operations (such as Insert, Update, or Delete) can be performed against them. Also, no indexes can be defined on the table. Oracle does plan to support writing to these tables in a future release.

* They don't support files larger than 2GB. If you attempt to access a file larger than 2GB, Oracle fails with the following error:

KUP - 04039: unexpected error while trying to find file

<file name> in director
<directory name>

* Certain commands against the table, such as ANALYZE, will fail.

SQL> analyze table products compute statistics;
analyze table products compute statistics

*
ERROR at line 1:
ORA-30657: operation not supported on external organized
Table

This limitation is important because most DBAs have scripts that regularly refresh object statistics based on a schema. If you try to generate statistics on an external table, the command will fail.

* The data in external tables isn't backed up as part of regular Oracle backup routines because it's outside the scope of the database.

[jadey]

c'est exactement ça merci