Command to create oracle tablespace and users

Command to create an oracle tablespace and user this article describes how to use commands to create an oracle user. SQLPLUS login system user! -- Create an instance:

Database Configuration Assistant

Create a database

Partition 1: query the physical path of the data file in the Table SYSTEM tablespace -- SELECT FILE_NAME FROM DBA_DATA_FILES WHERE (TABLESPACE_NAME = 'system'); copy the queried tablespace file address and copy the information in the create tablespace file column. 2: CREATE a TABLESPACE and set the file address 'size 200 m autoextend on next 50 m maxsize unlimited extent management local' to be queried by automatically scaling create tablespace TBS_ORCL_DEMO DATAFILE; -- if a U_DEMO USER exists, delete -- drop user "U_DEMO" CASCADE; 3: create user U_DEMO identified by 123456 default tablespace TBS_ORCL_DEMO quota unlimited on TBS_ORCL_DEMO QUOTA 100000 k on users account unlock; "U_DEMO" is the database user, 123456 is the user password, and TBS_ORCL_DEMO is the created tablespace. 4: Set User Permissions and authorize the User Role grant connect, RESOURCE, dba to U_DEMO; grant create session to U_DEMO; grant create procedure to U_DEMO;