ALTER TABLESPACE-DATAFILE

———-user’in sahip olduğu rollerin listesini verir—————-

select * from user_role_privs;

——————-tüm user’ları görmek için——————-

select username from dba_users;

—————————-ALTER TABLESPACE——–

————————tablespace’in adını değiştirir———–

ALTER TABLESPACE test RENAME TO test0;

———————tablespace’e datafile eklemek————–

alter tablespace test add datafile ‘D:\oracle\product\10.2.0\oradata\orcl\test2.dbf’size 10M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

————-tablespace’i 20mb olarak artırır————————-

ALTER TABLESPACE test AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED;

–tablespacedeki tüm datafile’lerin adını ve büyüklüğünü verir—–

SELECT file_name, bytes FROM sys.dba_data_files WHERE tablespace_name = ‘TEST’;

select file_name,file_id,tablespace_name,bytes,status,online_status from sys.dba_data_files where tablespace_name=’test’
————tablespace’i offline ve online duruma getirme——
alter tablespace test offline;
————- select * from hastalar;
alter tablespace test online;—————————-

————datafile’ı offline ve online duruma getirme——-

ALTER DATABASE DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\test2.dbf’ offline;

shutdown immediate;
startup mount;

ALTER DATABASE DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\test2.dbf’ online;

——–datafile’ın adını değiştirir———————–

sql>shutdown immediate;

manuel olarak,dizindeki ‘test’ datafile’ının adını değiştiriyoruz.

sql>HOST MOVE D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL2\TEST.DBF D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL2\INTERBASE.DBF

SQL>alter database rename file ‘D:\oracle\product\10.2.0\oradata\orcl2\test.dbf’ to ‘D:\oracle\product\10.2.0\oradata\orcl2\INTERBASE.dbf’;

sql>alter database open;
—————————————————
ALTER TABLESPACE test DROP DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\test2.dbf’;

———tabloyu başka tablespace’e taşıma———

ALTER TABLE table_name MOVE TABLESPACE tablespace_name