Announcement

Collapse
No announcement yet.

DBA.BG Database Support Community help

Collapse

Here you can find answers to questions about how the board works. Use the links or search box below to find your way around.

Generating script for Tablespace from current database

set trimspool on
set pages 0
spool gentbsp.sql
SELECT 'create tablespace'
||' '||tablespace_name
||' '||'logging'
||' '||'datafile'
||' '||file_name
||' '||'size'||' '||bytes
||' '||'EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO'
FROM dba_data_Files
spool off;
Working...
X