Create and expand tablespaces in Oracle (Linux supported)

1. Create a tablespace in Oracle

1. Create tablespace tianzh
2. Logging
3. Datafile'/Opt/oracle/oradata/dqjz/jwzh01.dbf'
4. Size 30720 m
5. Autoextend on
6. Next 50 m maxsize 32768 m
7. Extent management local;

2. Expand the tablespace based on the original tablespace

Alter tablespace retry ZH add datafile'/U01/app/oracle/product/10.2.0/oradata/dqjz/jwzh01.dbf'Size 10240 m; 3.

Copy others' code and use it later

/* Step 2: create a temporary tablespace */

1. Create TemporaryTablespace user_temp
2. Tempfile'D: \ oracle \ oradata \ Oracle9i \ user_temp.dbf'
3. Size50 m
4. AutoextendOn
5. Next50 m maxsize 20480 m
6. Extent managementLocal;

/* Step 2: create a data table space */

1. CreateTablespace test_data
2. Logging
3. Datafile'D: \ oracle \ oradata \ Oracle9i \ user_data.dbf'
4. Size50 m
5. AutoextendOn
6. Next50 m maxsize 20480 m
7. Extent managementLocal;

/* Step 2: create a user and specify the tablespace */

1. Create UserUsername identifiedBy Password
2. DefaultTablespace user_data
3. TemporaryTablespace user_temp;

/* Step 4: grant permissions to users */

Grant Connect, Resource, dbaToUsername;