Export / Import

[JamirJrParticipante]

assim vc pega as tablespaces q existem no banco antigo:

SELECT ‘create tablespace ‘
|| df.tablespace_name
|| CHR (10)
|| ‘ datafile ”’
|| df.file_name
|| ”’ size ‘
|| df.BYTES
|| DECODE (autoextensible,
‘N’, NULL,
CHR (10) || ‘ autoextend on maxsize ‘ || maxbytes
)
|| CHR (10)
|| ‘default storage ( initial ‘
|| initial_extent
|| DECODE (next_extent, NULL, NULL, ‘ next ‘ || next_extent)
|| ‘ minextents ‘
|| min_extents
|| ‘ maxextents ‘
|| DECODE (max_extents, ‘2147483645’, ‘unlimited’, max_extents)
|| ‘) ;’
FROM dba_data_files df, dba_tablespaces t
WHERE df.tablespace_name = t.tablespace_name;