oracle的数据库备份与常见问题
一.oracle数据库备份基本步骤
(1)打卡SQL plus 使用system用户登陆。
(2)连接sysdba用户:connect sys/password@databasename as sysdba
(3)停止数据库 :shutdown immediate
(4)到oracle路径下拷贝你的数据库文件夹。
(5)启动例程 :startup mount
(6)启动数据库 :alter database open
二.oracle用sys 登陆的方法(在system无法登陆的情况下):
用户名输入:sys/password as sysdba
三.The account is locked 的解决办法
用sys登陆后:alter user [username] account unlock
四.oracle修改用户密码
alter user [username] identified by [password]
五.停止和启动监听
lsnrctl stop
lsnrctl start
六.oracle清空表数据
Truncate Table [表名]
七.删除表
Drop Table [表名]
相关文档:
做数据库开发或管理的人经常要创建大量的测试数据,动不动就需要上万条,如果一条一条的录入,那会浪费大量的时间,本文介绍了Oracle中如何通过一条SQL快速生成大量的测试数据的方法。
产生测试数据的SQL如下:
SQL> select rownum as id,
2 &nbs ......
1、下载oracle软件
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
oracle-instantclient-basic-10.2.0.4-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
oracle-instantclient-devel-10.2.0.4-1.i386.rpm
2、安装rpm包
rpm -ivh oracle-instantclient-basic-10.2.0.4 ......
关键词:with read only
作用:用于指定所创建的试图不可以通过本视图更新表
执行一下SQL,创建表T,和两个试图V1,V2:
CREATE TABLE T(ID INTEGER);
CREATE VIEW V1 AS SELECT * from T;
CREATE VIEW V2 AS SELECT * from T WITH READ ONLY;
执行SQL:
INSERT INTO V1 VALUES(1);
--------------------
1 row cre ......
Oracle 10.1 Statistics:
In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics
The following table shows the 106 statistics that were added in Oracle 10.1:
Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent ......