Oracle Add data file create table space, create user code

1. Add a data file to create a tablespace

1 CREATE ' D:\ORACLE\11G\ORADATA\ORCL\TEST1. DBF'onNEXTSPACE

The deployment needs to change parts as needed:

Tablespace (table space) after the table space name TEST1;

DataFile (data file) path, red part of the code;

2, create user

1 --Create the user2 Create UserTEST13Identified byTEST14   defaulttablespace TEST15   TemporaryTablespaceTEMP;6 --Grant/revoke Role Privileges7 GrantConnect toTEST1;8 GrantDba toTEST1;

The deployment needs to change parts as needed:

Username TEST1 after user (user)

Identified by password TEST1

Default table Space TEST1 tablespace

Oracle Add data file create table space, create user code