PLSQL developer creates a tablespace for Oracle 10 GB

Log on to the Oracle database through PL/SQL, and then execute the menu: File/New/command window, open a command window, and then execute the script in the Command window to create and delete tablespaces.

Create a tablespace SQL> Create tablespace histdb datafile 'd:/Oracle/product/10.2.0/oradata/orcl/histdb. dbf' size 200 m autoextend on next 10 m maxsize unlimited; SQL> Alter database datafile 'd:/Oracle/product/10.2.0/oradata/orcl/histdb. dbf' autoextend on; 1) datafile: Tablespace data file storage path
2) Size: initially set to 200 m
3) uniform: the size of the specified area is 128 K. If not specified, the default area size is 64 K.
4) The space name histdb is not required to be the same as the data file name histdb. DBF. 5) autoextend ON/OFF Indicates that automatic expansion of tablespaces is enabled/stopped. 6) alter database datafile 'd:/Oracle/product/10.2.0/oradata/orcl/histdb. dbf' resize 500 m; // manually modify the data file size to 500 m Delete a tablespace Drop tablespace histdb including contents and datafiles;