新建表空间

drop tablespace customerchat;


CREATE TABLESPACE jx_bod LOGGING DATAFILE '/mnt/oradata/jx_bod'
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 1024M EXTENT MANAGEMENT LOCAL;


create temporary tablespace jx_bod_temp tempfile '/mnt/oradata/jx_bod_temp'
size 100m autoextend on next 32m maxsize 1024M extent management local;


create user jx_bod identified by jx_bod default tablespace jx_bod temporary tablespace jx_bod_temp;


grant connect,resource to jx_bod;

alter user jx_bod identified by jx_bod;

alter user jx_bod account unlock;

sqlplus jx_bod/jx_bod@jx_bod;