Posts Tagged ‘oracle’

Oracle 中的错误解释命令

星期六, 05月 31st, 2008
  • Oerr ora errorcode
  • Example

oracle@lnxoravm:194# oerr ora 1300
01300, 00000, “writable database required for specified LogMiner options”
// *Cause: Options were specified which required the database to be writable.
// *Action: Specify different options or open the database for write access.

ORA-12514

星期四, 05月 22nd, 2008

今天碰到一个错,很典型。

1. 错误 ORA-12514

C:\Documents and Settings\Administrator>sqlplus icmadmin/fvt6eip@rmdb

SQL*Plus: Release 10.2.0.3.0 – Production on Fri May 23 01:53:46 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Enter user-name:

(阅读全文……)

[Good Article]Initialization Parameter files: PFILEs vs. SPFILEs

星期一, 05月 5th, 2008

http://www.orafaq.com/node/5

使用 Transaction

星期六, 05月 3rd, 2008

A transaction is started by any valid DML statement, including INSERT,
UPDATE, and DELETE. A SELECT statement will execute a query against the
database but not start a transaction. ROLLBACK and COMMIT will end a
transaction but start another one. SAVEPOINT defines a named marker in
your transaction that allows data before it to be committed and following it
to be rolled back when the ROLLBACK TO savepoint statement is issued.

Oracle 学习资料收集

星期日, 03月 30th, 2008

最近做项目正好用到oracle,之前基本了解很少,正在苦读中。收集了一些好的站点和书籍推荐与此。

<–more–>

China Oracle User Group – 国内论坛,资料详尽。

Oracle 10g Online Documentation – Oracle 官方文档库,Oracle Conecpt , 2Days DBA 都不错。

http://asktom.oracle.com/ – 最具价值的Oracle技术资源基地。

推荐本盖国强写的《深入浅出Oracle》 , 看了半本了,写的非常好,适合初学者。