Shulou(Shulou.com)06/01 Report--

After logging in to the host directly;

If you need to convert the instance of the database, enter it in Windows. You need to enter set oracle_id=... under the root directory of ORACLE. Enter export ORACLE_SID=...

Authentication method: AIX echo $ORACLE_SID

Windows set oracle_id

input sqlplus /nolog directly;

Conn /as sysdba

After entering ORACLE interface

1) Increase data file size

Enter select from v$instance to query the database name currently in use

Enter select ts#,name from v$tablespace to query the TS corresponding to each current tablespace

Enter select name,bytes,status from v$datafile where ts#=10; query the file name corresponding to the table space with TS = 10

For temporary tablespaces:

Enter select name,bytes,status from v$tempfile where ts#=10;

You can enter col name format a30 to adjust the display length of the field.

Enter alter database datafile '+SZCG_ASM_GROUP/szcg/datafile/tbs_dxpt.dbf' resize 1500M,

For temporary tablespaces:

Input alrter database tempfile '+SZCG_ASM_GROUP/szcg/datafile/tbs_dxpt.dbf' resize 1500M;

For bigfile file processing format, enter alter tablespace system resize 1500M;

2) Increase the number of data files

Enter select from v$instance to query the database name currently in use

Enter select ts#,name from v$tablespace to query the TS corresponding to each current tablespace

Enter select name,bytes,status from v$datafile where ts#=10; query the file name corresponding to the table space with TS = 10

Type select free_mb from v$asm_diskgroup; to see how much free space ASM has left,

Enter desc v$asm_diskgroup; view ASM table structure

Enter alter tablespace system add datafile '+system_dg' size 100m;

For temporary tablespaces:

Enter alter tablespace temp add tempfile '+system_dg' size 2G;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.