conn sys/change_on_install as sysdba; create tablespace dev datafile "yourpath" size 10m; create user XXX identified by pass grant create table,create view,create index,create session to user XXX; alter user XXX quota 10m on tablespace dev conn XXX/pass; create table aaa (id,int) tablespace dev; @???.sql
如果不知道有那些数据字典视图
可以用 select * from dictionary 来看。
看视图里的字段用desc就可以了,
你要查的几个东西在
user_tables
user_indexs
user_views里面。
create tablespace dev
datafile "yourpath" size 10m;
create user XXX
identified by pass
grant create table,create view,create index,create session to user XXX;
alter user XXX quota 10m on tablespace dev
conn XXX/pass;
create table aaa
(id,int)
tablespace dev;
@???.sql