oracle初步使用

查看数据库实例状态

1.select instance_name,status from v$instance;

2.select * from v$nls_parameters;查看设置的字符集

3.在window 的数据库给开发人员新建用户及其表空间

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;

4.在linux的数据库新建一个用户及其表空间

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:\