---创建表空间
CREATE TABLESPACE fs12345 datafile
'F:\oracle\product\10.2.0\oradata\fs\fs12345.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
---删除表空间
drop tablespace fs12345;
--创建一个dblink连接
create public database link ToSF1 connect to baseset identified by "baseset" using
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sf1)
)
)' ;
--删除数据库链接。
drop public database link sf1;
---删除用户及其所属对象
drop user XXXX cascade ;