Oracle 11g Data Loading Methods
Data Loading:
SQL * LOADER
External table
Import/Export
SQL * LOADER:
SQL * LOADER is an Oracle tool that can load data from external data files to databases.
The command for running SQL * LOADER is sqlldr.
Two Sqlldr usage methods:
1. Use only one control file, which contains data
2. Use a control file (as a template) and a
Selection:32-bit memory is a bottleneck, it is already 64-digit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In the virtual machine installation, use the Hostonly way to set up the networkNote: The Internet adapter will be able to set up ICS (Internet Connection Sharing) to VMware network Adapter VMnet1So for the virtual machine, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24
SQL> select * from v $ version;
BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-Production
Sometimes there is a background wait event: db file async I/O submit
This w
How to manually delete an Oracle 11g database in Linux
The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment.
I installed the Oralce 11G database on CentOS 6.
Use SQLPlus or other command line tools you like to log on to the data
After migrating the data of a test system from Oracle 10 Gb to 11 GB, I heard the developers say that they failed to execute an SQL statement to create an index, but it can be executed normally in 10 Gb. This index is a function index with duplicate columns. It may be incorrect and this index is not useful. Therefore, you have never paid attention to this index. I felt quite interesting, so I tried it myself:
1. First, let's look at the
1, download Oracle 11g R2 for Windows version
Download Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
This includes two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip
2, the two compressed packets to the same directory, that is, "database", and then click the Extract directory under the "setup.exe" file:
3. In the "Config
following options:
ASM This is the preferred storage option for Oracle and is the only configuration supported in the RAC Standard Edition
OCFS2
Bare devices are not recommended, not only because they are deprecated by the new Linux kernel, but also not supported in Oracle 11.2
Network File System (NFS)
The Red Hat Global file System is only supported in Red Hat and
Oracle 11gThe clientLinuxThe configuration process is a little bit difficult, but as long as we configure step by step, there is nothing. This article describes how to configure the Oracle 11g client on Linux.
First download several compressed packages from OTN, for: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html, And then according t
the following query: [Email protected] rc.d]$ find-name ' k*oracledb ' ./rc2.d/k10oracledb ./rc4.d/k10oracledb ./rc6.d/k10oracledb ./rc1.d/k10oracledb ./rc0.d/k10oracledb [Email protected] rc.d]$ find-name ' s*oracledb ' ./rc5.d/s80oracledb ./rc3.d/s80oracledb [Email protected] rc.d]$ chkconfig--list oracledb OracleDB 0:off 1:off 2:off 3:on 4:off 5:on 6:off As in the previous OracleDB file, the first two lines of comments may not be written, you can use the file link: # ln-s/etc/init.d/oracledb
Background:The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size of the backup machine, modify the relevant memory parameters and start the database to the backup machine for two days. If no problem exists, then, double the physical memory of the previous host to switch the database to the slave host. The reason for
1. automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (The table contains the default user name and password ), the user name and password are all invalid. Finally, you have tried dbsnmp/dbsnmp, prompting you to be locked;2. Log On With sqlplus/as sysdba. The prompt is displayed.3.SQL> alter user dbsnmp account unlock;User altered.SQL> alter user dbsnmp identified by db
1. First download the oracle 11g x64 bit package from the official website.
:
Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip
Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip
2. Installation Package detection and Installation
[root@struggle ~]# rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-commo
Tags: style http io ar color OS sp for onInstall Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7)This article presents what to install the Oracle 11G on Oracle Enterprise Linux 7 (OEL7).read following article How to install
: # MV ORACLE/ETC/INIT.D # chkconfig--add Oracle # chkconfig--list Oracle view, so that Oracle can be switched on and off before shutdown immediate Rebooting the system, you can see starting Oracle in the boot process because we set the priority to 99, which is typically the
, Plsql Developer, bat. Can not be a bat to plsql developer to hack down, is Oracle development did not think of Win7? Baidu Baidu 、、、、 have the following method, the following method is I copy from the various versions out, but completely feasible, I personally tried.Disclaimer: The picture I intercepted from the Internet, because I did not install it, looks a little bitFirst of all: my machine is win7 64-bit flagship version, 64-bit
After the CentOS system is installed, you can start the installation of Oracle 11g. First, you must make some preparations.
Use commands to create an Oracle account and corresponding user groups
Create a folder and grant the Oracle user permissions, as shown in the commandUse the root account to make a series of chan
This morning, I completed the task I proposed for myself yesterday. I finally finished reading PDF files online. At the same time, I solved new problems and added the hand-shaped cursor to control translation. The modification of batch video conversion was not done, mainly because I attended an introduction lecture on Oracle Spatial 11g in the afternoon.
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.