Review database creation and modification

The creation and modification of the audit database are divided into four steps * // * Step 4: create a temporary tablespace */create temporary tablespace user_temp tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local;/* Step 4: create a data table space */create tablespace user_data logging datafile 'd: \ oracle \ oradata \ Oracle9i \ user_data.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; /* Step 2: create a user and specify the tablespace */create user username identified by password default tablespace user_data temporary tablespace user_temp; view the tablespace and the remaining tablespace select total. tablespace_name, round (total. MB, 2) as Total_MB, round (total. MB-free. MB, 2) as Used_MB, round (1-free. MB/total. MB) * 100, 2) as Used_Pct from (select tablespace_name, sum (bytes)/1024/1024 as MB from dba_free_space group by tablespace_name) free, (select tablespace_name, sum (bytes) /1024/1024 as MB from dba_data_files group by tablespace_name) total where free. tablespace_name = total. tablespace_name; for example, alter tablespace app_data add datafile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ app03.dbf' SIZE 50 M; Meathod2: ADD a data file, and allow automatic growth of the data file alter tablespace app_data add datafile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ APP04.DBF 'SIZE 50 m autoextend on next 5 m maxsize 100 M; meathod3: allow existing data files to automatically grow alter database datafile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ APP03.DBF 'autoextend on next 5 m maxsize 100 M; Meathod4: manually change the size of an existing data file. alter database datafile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ APP02.DBF 'resize 100 M;