tablespace COALESCE or shrinking datafile

[BeefStu]

are you using locally managed TS with segment space management auto or dictionary managed TS?

Thanks,

locally managed TS with segment space management.

Here is a typical example of how I create tablespaces. Depending on what tables are going in the TS most of the time I increase the maxsize, but try to stay away from "unlimited" option.

CREATE TABLESPACE "xxx"
DATAFILE '/oracle/data/pri/xxx01.dbf' SIZE 50M
autoextend on NEXT 50M maxsize 200M
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;