demo08.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 17 行

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;