Label:1.Linux Environment Configuration Preparation Environment: Linux:redhat Enterprise 5.4,db:oracle 11g R2 x64,oracle installed into the/home/oralce_11 directory. The configuration process is as follows: (mostly online content, individuals also follow the online steps) 1) Check the basic requirements (for the cool server, this must be satisfied with the requirements, can skip)Memory sizegrep memtotal/pro
the cache without reading the data from the rollback segment. The answer to this question is complete assurance of completeness. Because the result set is cached independently, any other DML statements will not affect the contents of the result set during the query, thus guaranteeing the integrity of the data.
2. Object-dependent improvement
Before 11g, if a function or view depended on a table, once the table had a structural change, the function
configuration are the most critical parts. Iv. Unloading of the database Go to the installation directory and go to product-->11.2.0-->dbhome_1-->deinstall-->deinsytall.bat Continue through the carriage return to achieve the next step, come here follow the prompts to enter Y Go back in and enter Y here Continue to enter the database after the cleanup operation, a few minutes (in fact, a long time), the database is uninstalled, the process may fail, restart the computer or shut down the
1. Oracle 11g R2 Installation Manual (graphic tutorial) for Windows1. Download the Oracle 11g R2 for Windows version, as followsOfficial website:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010
Label:First install ha-instant Client-v11.2.0.3.0-x86.rar : Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x86.rar Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x64.rar Then perform the installation of ODBC a must choose to install Add environment variable: Tns_admin value:%oracleclient%/network/admin Modify Tnsnames.ora to add the server information that
of using official documents to view help information. For friends who have no idea of the official documents, I hope to help you. This is the official document. There's nothing magical about it. And this is a tool for learning Oracle.Want to work with Oracle, read official documentation This is one of the major skills.*********************************************** declaration ***************************************** *******original works, from the
1, to use PL/SQL need to install the Oracle client (this is necessary, otherwise plsql will not use, this client can go to Oracle official Web download, called instance client, as far as possible with the newer version on it, The Windows version of the big is more than 50 m, as well as the lite version of more than 20 m, address: http://www.oracle.com/technology/
ObjectiveEnvironment Description: In this experiment, the main implementation of the Rhel-based 6.5 64bit system successfully installed Oracle 11g R2 64bit, the experimental platform based on VMware VSphere. Media Download: VMware ESXi 5.5.0 (1331820) Download Link: Http://yunpan.cn/QiBnp2xxpFjaD access password 2ec0 R
Tags: http io using file SP data on code AD1, download Oracle 11g R2 version of Windows, the official following:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip2. Unzip two compressed packets into the same directory (the default is database).3, execute
Tags: listen file GBK reader operation 32-bit service login OtnThank the original author, the original link: https://wenku.baidu.com/view/433d0b544a7302768f993926.html With the actual installation, Oracle can be successfully installed on a 64-bit Windows7 by the following steps. The following is a detailed download, installation, configuration process. Strictly follow this procedure, can be installed comple
Label:After installing Oracle (64-bit), PL/SQL developer, execute PL/SQL occurs for example the following error:On the Internet, my PL/SQL developer is incompatible with Oracle, that is, PL/SQL does not support 64-bit Oracle, so the next 32-bit orcaleclient will be configure
Tags: Manager 11.2 lin ERP Change write img for actions1, ready to installView the current version of Oracle and make sure it is older 11.2.0.1[[Email protected]_test_121_90 ~]$ rlwrap sqlplus/as sysdba
sql*plus:release 11.2.0.1.0 Production on Fri Mar 17 15 :
Copyright (c) 1982, 20:45, Oracle. All rights reserved.
Connected to:
Oracle Database
Label:I Linux small white, because the project must be under Linux under the use of Oracle began to explore. Installation process encountered a variety of problems and reasons, today tidy up the convenience of the back can be less detours.Indicate
The installation process takes note of the user who is currently making the mistake, and executes the./runinstaller is operated under the #su-oracle user.
Comparison:Plsqldev: Third-party, fast startup software, slow execution of SQL queriesSqldeveloper:oracle company, slow startup software, fast execution of SQL queriesObjective:To connect a local Oracle Server service-side instance using SqldeveloperUsing Sqldeveloper to connect to a remote Oracle client instanceEnvironment:Oracle 11gOracleClient 11g ODACOracle S
Tags: enter none sid \ n Instance term Oracle names post The traditional way to connect to a remote database is to install an Oracle locally. Then use the Network configuration Assistant. Then connect with PL/SQL Dev. It is not very convenient because the database needs to be installed locally?The second method is described below1, first to the Oracle website to
Oracle 11g import and export table method summary also said, the above method: Export: www.2cto.com Fang Yi: 1. first set oracle_sid. 2. find the bin directory. my options are D: \> cd D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ BIN 3. execute exp scott/root @ jxgl21 file = D: \ t. dmp tables = (S) // S indicates the table name or exports the entire database exp scott/root @ jxgl21 file = D: \
Install the Oracle database under a 64-bit operating system and download a new 64-bit database (if the 32-bit database is installed on a 64-bit operating system, either the client or the server side, do not select the C:\Program Files (x86) path, Instead, the installation path will be modified (x86) removed). All the way installed, no problem, after the installation completed Plsql develop, prompting 32-bit
Tags: ext Let pen he play back center bre screensSharing a form to generate Excel file for SQL query in Oracle Forms. This form can is used in Oracle Forms 6i and 10g/11g. Below is the shot of this form and could was download from the following LINK:EXCEL_REP.FMB A procedure Create_ Excel_file is attached in program U
Tags: window8 64-bit + Oracle1) Install Oracle 12c 64-bit2) Installing the 32-bit Oracle Client (INSTANTCLIENT-BASIC-NT-12.1.0.1.0.ZIP)Download Instantclient-basic-win32-11.2.0.1.0.zip, must be the Win32 version, the Oracle official website downloads, unzip it to the Oracle
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.