Add Data File Linux

Table of Contents

Add Data File Linux. 1

Listanje datafiles tablespace users. 1

Eksplicitno imenovanje data file. 1

OMF Oracle Managed Files. 1

Promena imena datafile online. 1

Listanje datafiles tablespace users

SQL> select banner_full from v$version;

BANNER_FULL

----------------------------------------------------------------------------------------------------------------------------------------------------------------

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.20.0.0.0

rlsqlplus

Enter user-name: sys/SysPassword1@pdb1 as sysdba

SQL> select file_name from dba_data_files where TABLESPACE_NAME='USERS';

FILE_NAME

--------------------------------------------------------------------------------

/u02/oradata/CDB1/pdb1/users01.dbf

/u02/oradata/CDB1/pdb1/users02.dbf

/u02/oradata/CDB1/pdb1/users03.dbf

/u02/oradata/CDB1/pdb1/users04.dbf

/u02/oradata/CDB1/pdb1/users05.dbf

Eksplicitno imenovanje data file

SQL>  ALTER TABLESPACE USERS ADD DATAFILE '/u02/oradata/CDB1/pdb1/users07.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;

Tablespace altered.

OMF Oracle Managed Files

SQL> show parameter db_create_file_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest                  string      /u02/oradata

SQL> ALTER TABLESPACE USERS ADD DATAFILE;

SQL> col file_name format a120

SQL> select file_name from dba_data_files where TABLESPACE_NAME='USERS';

FILE_NAME

------------------------------------------------------------------------------------------------------------------------

/u02/oradata/CDB1/pdb1/users01.dbf

/u02/oradata/CDB1/pdb1/users02.dbf

/u02/oradata/CDB1/pdb1/users03.dbf

/u02/oradata/CDB1/pdb1/users04.dbf

/u02/oradata/CDB1/pdb1/users05.dbf

/u02/oradata/CDB1/pdb1/users07.dbf

/u02/oradata/CDB1/030C3731964504ADE0635802020A1C1E/datafile/o1_mf_users_ljr8l31r_.dbf

Promena imena datafile online

SQL> ALTER DATABASE MOVE DATAFILE '/u02/oradata/CDB1/030C3731964504ADE0635802020A1C1E/datafile/o1_mf_users_ljr8l31r_.dbf'

TO '/u02/oradata/CDB1/pdb1/users08.dbf';

SQL> select file_name from dba_data_files where TABLESPACE_NAME='USERS';

FILE_NAME

------------------------------------------------------------------------------------------------------------------------

/u02/oradata/CDB1/pdb1/users01.dbf

/u02/oradata/CDB1/pdb1/users02.dbf

/u02/oradata/CDB1/pdb1/users03.dbf

/u02/oradata/CDB1/pdb1/users04.dbf

/u02/oradata/CDB1/pdb1/users05.dbf

/u02/oradata/CDB1/pdb1/users07.dbf

/u02/oradata/CDB1/pdb1/users08.dbf

7 rows selected.