su - oracle
sqlplus "/as sysdba"
删除
drop user [color=red]wqettest [/color]cascade;
查看oracle表空间文件
select tablespace_name, file_id, file_name, round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;
创建
CREATE TABLESPACE [color=red]name[/color]
DATAFILE '[color=red]E:\oracle\product\10.2.0\oradata\orcl\name.ora[/color]' SIZE 600M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
create user [color=red]username[/color] identified by [color=red]password[/color] default tablespace [color=red]name[/color] temporary tablespace [color=red]temp[/color];
grant connect,resource,create public database link,create view,drop public database link to [color=red]username
有时需要DBA
GRANT CONNECT TO zjgsg;
GRANT RESOURCE TO zjgsg;
GRANT dba to zjgsg;
grant imp_full_database to XMISDATA;
查询外键关联
select * from user_cons_columns cl where cl.constraint_name = '外键名称'[/color];
sqlplus "/as sysdba"
删除
drop user [color=red]wqettest [/color]cascade;
查看oracle表空间文件
select tablespace_name, file_id, file_name, round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;
创建
CREATE TABLESPACE [color=red]name[/color]
DATAFILE '[color=red]E:\oracle\product\10.2.0\oradata\orcl\name.ora[/color]' SIZE 600M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
create user [color=red]username[/color] identified by [color=red]password[/color] default tablespace [color=red]name[/color] temporary tablespace [color=red]temp[/color];
grant connect,resource,create public database link,create view,drop public database link to [color=red]username
有时需要DBA
GRANT CONNECT TO zjgsg;
GRANT RESOURCE TO zjgsg;
GRANT dba to zjgsg;
grant imp_full_database to XMISDATA;
查询外键关联
select * from user_cons_columns cl where cl.constraint_name = '外键名称'[/color];