demo08.sql

Expert Oracle Database Architecture 9i and 10g sql源码

create or replace directory tmp as '/tmp'
/
create table all_objects_unload
organization external
( type oracle_datapump
  default directory TMP
  location( 'allobjects.dat' )
)
as
select
*
from all_objects
/
select dbms_metadata.get_ddl( 'TABLE', 'ALL_OBJECTS_UNLOAD' )
  from dual;