查看数据库实例状态
1.select instance_name,status from v$instance;
2.select * from v$nls_parameters;查看设置的字符集
desc dba_data_files
col file_name for a50
col tablespace_name for a15
select file_name,tablespace_name from dba_data_files;
create tablespace bank_tbs
datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACL\bank_data02.dbf'
size 5M autoextend on maxsize 100;
create user bankuser
identified by bankpwd
default tablespace bank_tbs;
grant connect,resource to bankuser;
创建表之后select tacle_name,tablespace_name from user_tables;
查看用户具有的角色权限 select * from user_role_privs;
create tablespace bank_tbs
datafile 'u01/app/oracle/oradata/orcl/bank_data01.dbf'
size 5M autoextend on maxsize 10G;
之下和window操作一样
5.数据的导入和导出
exp bankuser/bankpwd@ORCL file=D:\bankuser.dmp log=D:\bankuser.log
imp bankuser/bankpwd@ORCL fromuser=bankuser touser=bankuser
file=D:\ log=D:\