oracle 11g book

The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the PL/SQL developer does not recognize th

is completecan use Sqlplus to test, the new Open a command window, enter the Sqlplus, and then enter the user name and password, you can test, here do not do too much introduction.Configuring monitoring and local network services1) in Oracle User's graphical interface Oracle user, the new terminal is opened, the input command NETCA will pop up the following interface.2) Create a listening service (acting a

information, this feature can package information related to an event. You can also send the packaging information to the Oracle Support Team.· Feature-based Patching)During patching, this feature makes it easy for you to differentiate the features in the patch package that you are using and must play. Enterprise Manager (EM) enables you to subscribe to a feature-based patch service, so Enterprise Manager can automatically scan for the features you a

After connecting to the VPN, other network connections will be poor, but you need to constantly check the information during installation, So I quickly found a dormitory book for emergency purposes. 4. remote connection The installation of Oracle software depends on OUI, so it is necessary to solve the problem of graphical interface to remote minicomputers. My own machine is XP. I searched the internet an

Oracle Core Technology notes (this book is not carefully read, so you need to read it later ~~), Oracle Core TechnologyOracle Core Technology jump to: navigation, search Directory Start 1 2redo and undo 3. Transactions and consistency 4. locks and latches 5 cache and copy 6. Write and restore 7. Analysis and Optimi

This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and some new features of the

, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The database has been detached.The ORACLE routine has been disabled.SQL> startupThe

Tags: style blog http io using ar strong file data1. Select the database used by biAs a bi system, the use of a powerful background database software is essential. There are many database products with high performance and stability, such as IBM DB2, Oracle, GP and so on. These databases are commonly used in everyday enterprise-level BI systems. In terms of my personal work experience and the company's recommended use of databases,

---------- ----------------------------------------1 First row of data3 third row of dataNext, perform a recovery operation on the data you just deleted:1. Turn on the mobile function of the tableSql> ALTER TABLE TB_FLASH1 enable row movement2/The table has changed.2. Restore the table to the time when the data was deleted (note that the time is as close as possible to the time you deleted the data or slightly forward)Sql> Flashback table Tb_flash1 to timestamp2 To_timestamp (' 2013-01-26 15:58:

Oracle 11g Client Configuration First download a few compressed packages from Otn Download the address: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html Then depending on your platform, choose a different download, I was installed under Rhel5, so I chose the Linux x86 and downloaded the following 2 packages:The Instantclient-basic-linux32-11.1.0.7.zip Basic package provides suppor

Some ASP. NET + Oracle 11G systems write-and-learn essays, including referencing Oracle's official data provider and changing the date format of Oracle storage. (8) Reference Oracle's official data provider At the end of the last post "Oracle 11g Study Notes (3)", an ASP