1.--登录Oracle
sqlplus / as sysdba;
2.创建表空间
create tablespace li_data
logging
datafile 'D:\oracledata\li_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
3.创建用户名并指定表空间
create user test identified by test
default tablespace li_data ;
4.用户授权
grant connect,resource,dba to test;
5.登录你新创建的用户
conn test/test
6.执行脚本 (@+你的sql脚本地址)
@F:/SqlDate/oracle_sql/yycg_table.sql
批量执行sql脚本,可以参考下面这篇博客
https://www.cnblogs.com/mq0036/p/4724466.html
附:因为我们数据库要统一编码集(ZHS16GBK),附下 修改字符编码集的步骤
--查看当前字符编码集
select userenv('language') from dual;
将下面的步骤一一执行,就可以修改字符编码集了
conn / as sysdba;
shutdown immediate;
startup mount;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
alter database open;
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
shutdown immediate;
startup;