Log in directly after the host;
If you need to convert an instance of a database, enter it in Windows, enter the set oracle_id= ... in the root directory of Oracle, and enter Export oracle_sid= in the AIX system ....
Authentication method: AIX echo $ORACLE _sid
Windows Set oracle_id
Direct input sqlplus/nolog;
Direct Input Conn/as SYSDBA
After entering the Oracle interface
1) Increase data file size
Enter Select
From v$instance, query the database name now used
Enter select Ts#,name from v$tablespace to query the TS that are now corresponding to each table space
Enter select Name,bytes,status from V$datafile where ts#=10; query table space for TS 10 file name
If this is a temporary tablespace:
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
Input ALTER DATABASE datafile ' +SZCG_ASM_GROUP/SZCG/DATAFILE/TBS_DXPT.DBF ' resize 1500M,
If this is a temporary tablespace:
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 files in the data file
Enter SelectFrom v$instance, query the database name now used
Enter select Ts#,name from v$tablespace to query the TS that are now corresponding to each table space
Enter select Name,bytes,status from V$datafile where ts#=10; query table space for TS 10 file name
Enter select FREE_MB from V$asm_diskgroup; see how much free space asm has,
Input desc V$asm_diskgroup; View ASM Table Structure
Input alter TABLESPACE system add datafile ' +system_dg ' size 100m;
If this is a temporary tablespace:
Input Alter tablespace temp add tempfile ' +system_dg ' size 2G;
Table space for Oracle Extended database
