oracle建表,建库,建用户,分配空间sql语句
create user ljdb identified by ljdb;
Create tablespace ljdb datafile 'd:\ORA_DATABASE\ljdb.dbf' size 10m;
alter database datafile 'd:\ORA_DATABASE\ljdb.dbf' autoextend on;
alter user ljdb default tablespace ljdb;
grant create session,create table,unlimited tablespace,dba to ljdb;
只需要使用替换将ljdb替换为相应的表空间即可