SSH sqlplus 创建库表

# 切换到Oracle用户
[root@xshxc ~]
[root@xshxc ~]# su - oracle
Last login: Thu Mar 11 09:37:03 CST 2021 on pts/0
[oracle@xshxc ~]$
# 登录sqlplus
[oracle@xshxc ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 11 09:44:01 2021
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
SQL> 
SQL> 
-- 连接Oracle
SQL> 
SQL> connect /as sysdba;
Connected.
SQL> 
-- 添加表空间、用户、授权等
-- test
SQL> 
SQL> create tablespace test datafile '/u01/app/oracle/oradata/orcl11g/test.dbf' size 1024m autoextend on next 200m maxsize unlimited;
Tablespace created.
SQL> create user test IDENTIFIED BY test DEFAULT TABLESPACE test TEMPORARY TABLESPACE temp QUOTA 2G ON test;
User created.
SQL> grant connect,resource,create any table,drop any table,create sequence,drop any sequence,create any trigger,create any view  to test;
Grant succeeded.
SQL> grant imp_full_database to test;
Grant succeeded.
SQL>