pl/sql tablespace

By ukmodak | June 6th 2022 12:23:03 PM | viewed 46 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 : 9223

Today :8

Today Visit Country :

  • United States