chen_yi_ping的专栏

--"一对一"关系表的创建 --主表 create table tab_student ( id number, name varchar2(32), address varchar2(32), primary key(id) ); --从表 create table tab_IdCard ( sid number primary key, num number uniq

右键Net Configuration Assistant属性，勾选以管理员的身份运行；

--创建表空间 CREATE TABLESPACE CSS DATAFILE 'F:\oracle\product\10.2.0\oradata\orcl\cssdata.dbf' SIZE 500M UNIFORM SIZE 128k; --创建用户 create user cssadmin identified by "css.2010" default tablespac

select current_size from v$buffer_pool;   select * from v$sga; select df.tablespace_name "表空间名",totalspace "总空间M",freespace "剩余空间M", round((1-freespace/totalspace)*100,2) "使用率%" from (select t