pl/sql tablespace

By ukmodak | March 31st 2024 10:32:28 AM | viewed 238 times
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;
bONEandALL
Visitor

Total : 20169

Today :16

Today Visit Country :

  • China
  • United States
  • United Kingdom
  • Portugal
  • Canada