CREATE TABLESPACE users
DATAFILE 'user_orderpdbs_data.dbf'
SIZE 1m;
or
CREATE TABLESPACE USERS
DATAFILE 'D:\app\Administrator\oradata\ORCL\5180C0096CEF45D789B148BF37633C44\DATAFILE\users_orderpdbs_data.DBF'
SIZE 500M
AUTOEXTEND ON NEXT 200M MAXSIZE 5120M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M
PERMANENT
ONLINE
LOGGING;
ALTER TABLESPACE users
ADD DATAFILE 'D:\app\Administrator\oradata\ORCL\5180C0096CEF45D789B148BF37633C44\DATAFILE\users_orderpdbs_data.DBF'
SIZE 1000M;
ALTER TABLESPACE users COALESCE;
or
alter database datafile 'D:\app\Administrator\oradata\ORCL\5180C0096CEF45D789B148BF37633C44\DATAFILE\users_orderpdbs_data.DBF' autoextend on maxsize unlimited;
DROP TABLESPACE users
INCLUDING CONTENTS
CASCADE CONSTRAINTS;
