--create tablespace
create tablespace ilog
datafile 'F:\oracle\product\10.2.0\oradata\rtszhxu\ilog.def' size 100M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
-- Create the user
create user ilog
identified by "ilog"
default tablespace ILOG
temporary tablespace TEMP
profile DEFAULT
quota unlimited on ilog;
-- Grant/Revoke role privileges
grant connect,dba to ILOG;
(grant resource to ILOG;
-- Grant/Revoke system privileges
grant create any index to ILOG;
grant create any sequence to ILOG;
grant create any table to ILOG;
grant create any view to ILOG;
grant drop any index to ILOG;
grant drop any sequence to ILOG;
grant drop any table to ILOG;
grant drop any view to ILOG;
grant select any sequence to ILOG;
grant select any table to ILOG;
grant unlimited tablespace to ILOG;
grant update any table to ILOG;)
查询表空间
SELECT *
FROM DBA_TABLESPACES
where TABLESPACE_name not in
('SYSAUX', 'SYSTEM', 'USERS', 'UNDOTBS1', 'TEMP')
order by TABLESPACE_name;
查询用户
SELECT a.*
FROM DBA_USERS a
where default_tablespace not in
('SYSAUX', 'SYSTEM', 'USERS', 'UNDOTBS1', 'TEMP')
order by a.default_tablespace;
数据库连接串
在D:\oracle\product\10.2.0\db_1\network\ADMIN下的tnsnames.ora里添加
INTEGERTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.79)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jrule)
)
)
create tablespace ilog
datafile 'F:\oracle\product\10.2.0\oradata\rtszhxu\ilog.def' size 100M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
-- Create the user
create user ilog
identified by "ilog"
default tablespace ILOG
temporary tablespace TEMP
profile DEFAULT
quota unlimited on ilog;
-- Grant/Revoke role privileges
grant connect,dba to ILOG;
(grant resource to ILOG;
-- Grant/Revoke system privileges
grant create any index to ILOG;
grant create any sequence to ILOG;
grant create any table to ILOG;
grant create any view to ILOG;
grant drop any index to ILOG;
grant drop any sequence to ILOG;
grant drop any table to ILOG;
grant drop any view to ILOG;
grant select any sequence to ILOG;
grant select any table to ILOG;
grant unlimited tablespace to ILOG;
grant update any table to ILOG;)
查询表空间
SELECT *
FROM DBA_TABLESPACES
where TABLESPACE_name not in
('SYSAUX', 'SYSTEM', 'USERS', 'UNDOTBS1', 'TEMP')
order by TABLESPACE_name;
查询用户
SELECT a.*
FROM DBA_USERS a
where default_tablespace not in
('SYSAUX', 'SYSTEM', 'USERS', 'UNDOTBS1', 'TEMP')
order by a.default_tablespace;
数据库连接串
在D:\oracle\product\10.2.0\db_1\network\ADMIN下的tnsnames.ora里添加
INTEGERTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.79)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jrule)
)
)