表空间
- 建用户时指定配额
SQL> create user java identified by oracle default tablespace users temporary tablespace temp quota 100m on users quota 100m on system;
--注意temp表空间不支持表空间配额
2)更改用户表空间配额
grant unlimited tablespace to java;--不对用户作配额限制
alter user java quota unlimited on users;--对指定表空间不做限额
alter user java quota 1000m on users;--指定用户在某表空间限制
revoke unlimited tablespace from java;--收回用户的unlimited tablespace权限
alter user java quota 0 on users;--针对alter … quota unlimited …;
--如果用户已经被授予了unlimited tablespace权限的话，那么alter user java quota 0 on users;限制是不起作用的
创建DBLink
| 类型 | Owner | 描述 |
|---|---|---|
| Pr ivate | 创建database link的user拥有该database link | 在本地数据库的特定的schema下建立的database link。只有建立该database link的schema的session能使用这个database link来访问远程的数据库。同时也只有Owner能删除它自己的private database link。 |
| Public | Owner是PUBLIC. | Public的database link是数据库级的，本地数据库中所有的拥有数据库访问权限的用户或pl/sql程序都能使用此database link来访问相应的远程数据库。 |
| Global | Owner是PUBLIC. | Global的database link是网络级的，When an Oracle network uses a directory server, the directory server automatically create and manages global database links (as net service names) for every Oracle Database in the network. Users and PL/SQL subprograms in any database can use a global link to access objects in the corresponding remote database. Note: In earlier releases of Oracle Database, a global database link referred to a database link that was registered with an Oracle Names server. The use of an Oracle Names server has been deprecated. In this document, global database links refer to the use of net service names from the directory server. |
-- 创建
create database link dblink名称 connect to 远程用户名 identified by "密码" using 'ip:端口/sid';
-- 创建后使用
select * from abc@dblink名称
调整表空间文件大小
/// 获取指定表空间和位置
SELECT FILE_ID, FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'SYSTEM';
/// 获取上一步需要调整的表空间文件的实际大小
SELECT MAX(BLOCK_ID)*8/1024 FROM DBA_EXTENTS WHERE FILE_ID=1;
/// 调整到上一步查询到的实际大小，只能大于不能小鱼
ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf' RESIZE 4000M;
