Complete process of creating user authorization and importing data in Oracle

Create user _ authorization _ in Oracle and import data

Complete process: create users, create tablespaces, authorize, and create tables

L create a user

Create user BBS identified by bbs123;

 

L create a tablespace

Create tablespace ts_bbs datafile 'e:/BBS/bbs_data.dbf' size 100 m;

The tablespace directory must be created manually.

 

L allocate the tablespace to the user

Alter user BBS default tablespace ts_bbs;

 

L authorize the user

Grant create session, create table, create view, create trigger, create sequence, unlimited tablespace to BBS;

 

L log on to the BBS to create a table, TT

Create Table TT ( Tt_id number (10) );

 

Or import an SQL file.

@ File path example: @ C:/data. SQL