-----------------------------------------------------------------------------------
DOS:
1. sqlplus
2.
用户名:sqlplus 、conn
密码:as sysdba 、as sysdba
解锁:
3. ALTER USER DBSNMP ACCOUNT UNLOCK;
解锁:system
4. alter user system identified by manager;
5. 连接:connect system/manager
查看用户权限列表:
select * from dba_users;
-------------------------------------------------------------------------------------
--删除表空间:
drop tablespace bjzyy2009 including contents and datafiles
--创建表空间:
CREATE TABLESPACE bjzyy2009 DATAFILE
'F:/oracle/product/10.2.0/db_1/database/bjzyy2009.dbf' SIZE 2048M
DEFAULT STORAGE
( INITIAL 64K NEXT 64K MAXEXTENTS UNLIMITED PCTINCREASE 50 );
create tablespace bjzyy2009
logging
datafile 'bjzyy2009.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
--删除用户
drop user bjzyy cascade;
--建立用户:
CREATE USER bjzyy2009 IDENTIFIED BY bjzyy2009
DEFAULT TABLESPACE bjzyy2009;
--赋予权限:
GRANT CONNECT TO bjzyy2009;
GRANT DBA TO bjzyy2009;
GRANT resource TO bjzyy2009;
--备份数据库:
exp 用户名/密码@数据库全局名 file=导出文件放置的位置 owner=(用户名)
exp jjjw2008/jjjw2008@orcl owner=jjjw2008 file=d:/强智科技/数据库备份/jjjw200906121030.dmp;
导入数据:
$imp bjzyy2009/bjzyy2009@orcl190 file=F:/北京中医/bjzyy201001141030.dmp full=y ignore=y