先用在sqlplus下面用
system/manager@servicename登录进去,此处servicename是你在net8里面配置的servicename
然后用如下语句
grant connect,resource to user_name identified by password;
然后你就可以conn user_name/password@servicename
登录到该用户下面建表
create table(
....
);
system/manager@servicename登录进去,此处servicename是你在net8里面配置的servicename
然后用如下语句
grant connect,resource to user_name identified by password;
然后你就可以conn user_name/password@servicename
登录到该用户下面建表
create table(
....
);
PL/SQL DEVELOPER
在建立新DB或表时不会建立新的表空间
如果需要建立新的用户表空间,语法大致如下:
CREATE TABLESPACE "tablespace_name"
LOGGING
DATAFILE '数据文件全路径(可以有多个)' SIZE 5M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
如果不新建用户,则表存在于所登陆的用户。
SQL> conn system/manager 创建新的用户:如user1/pass1,赋予connect,resource权限。
SQL> grant connect,resource to user1 identified by pass1; SQL> conn user1/pass1
SQL> create table test(a number,b char(19));
SQL> insert into test values(1,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'));
SQL> insert into test values(2,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'));
SQL> insert into test values(3,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'));
SQL> insert into test values(4,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'));
SQL> insert into test values(5,to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'));
SQL> commit; SQL> select * from test; A B
---------- -------------------
1 2000-11-28 20:27:33
2 2000-11-28 20:27:36
3 2000-11-28 20:27:38
4 2000-11-28 20:27:40
5 2000-11-28 20:27:52