When Oracle 11g is exported using EXP, empty tables cannot be exported, and 11 gexp
I. cause:There is a new feature in 11G. When the table has no data, no segment is allocated to save space.1. insert a row and then roll back to generate a segment.This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be export
Install ORACLE 11g R2 on CentOS 5.5. Tutorial 1: prerequisites 1. Prepare CentOS. First, what is the most important: partition is the most important. Obviously, the larger the partition, the better, especially the larger the SWAP space, at least 2 GB. Second, for beginners, there are two points to note. First, it is best to install the software in full compliance; second, remove the firewall, SElinux, and s
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
, change back to db_name = 'symp3 ', the same db_name should be set for the same DG -- The following is the configured backup database parameter file, which only lists the modified parts. If the original pfile file contains the same entries, you can comment on it or delete [Oracle @ linux3 ~]. $ Tail-20 $ ORACLE_HOME/dbs/initsybo5.oradb _ unique_name = sybo5log_archive_config = 'dg _ Config = (sybo3, sybo5) 'Log _ archive_dest_1 = 'location =/u01/data
Before Oracle 11g, adding a column to a large table and setting the default value would be a tragedy. sometimes you have to select the online redefinition function to achieve this requirement. adding new columns and setting the default values in 11 GB only allows you to modify the data dictionary to achieve this function, greatly improving the efficiency.Add 10g columns (default)
SQL> select * from
1. DB_BLOCK_CHECKSUM parameter description
Before Oracle 10.2.0.3:
DB_BLOCK_CHECKSUM has two options: TRUE and FALSE. The default value is TRUE.
In Oracle 10.2.0.3:
DB_BLOCK_CHECKSUM has three options: OFF | TYPICAL | FULL. The default value is TYPICAL.
In Oracle 11g:
DB_BLOCK_CHECKSUM has five options: OFF | FALSE | T
Welcome to the Oracle community forum and interact with 2 million technical staff. On Monday, Oracle announced the beta version of OracleDatabase11g at its user conference. during a keynote speech at the OracleOpenWorld conference, ChuckRozwat, executive vice president of Oracle server technology, said that the beta OracleDatabase11g contains a solution package
Oracle 11g, oracle11g
General requirements for software environments
RHEL 5. x System and RHEL 6. x System
Graphical desktop environment + development tools + Chinese Java support
-- When installing in RHEL 6. x, ksh needs to use the 5. x software package instead.
Preparations:
Yum install yum *
Yum groupinstall "X Window System" "desktop platform" "Chinese support" "development tools"
[Root @ dbserver ~]
Installing Oracle 11g R2 silently in CentOS
I,Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlOracle 11g online documentation:Http://www.oracle.com/pls/db112/homepage
Ii. System RequirementsMemory: 1 GB (minimum official requirement: 1 GB)Hard Disk: 40 GB (4.29G and 1.7G data files required for Enterprise Edition installation)
Ch
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
How to fix the standby database after ORACLE 11G replica uard Failover, and restore uardfailoverProblem scenarios after failover:Due to the failover test, a standby database has been changed to the primary database. How can I change this new primary database (the original standby database) back to the standby database?Both are primary, p1, and p2. How can I set one primary database 1 to p1, And the other pr
authentication delay Ah, will be stuck in the database, the user is not connected up. Go to block the password delay verification:
sql> ALTER SYSTEM SET EVENT = ' 28401 TRACE NAME ' CONTEXT FOREVER, Level 1 ' SCOPE = spfile; System altered. Sql> create Pfile from SPFile; File created. Sql> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Sql> startup
Oracle's official documentation-related notes: For your reference only, welcome to correct, make suggestions oh 650) this.width=650; "src=" Http://img.baidu.com/hi/jx2/j_0002.gif "alt=" j_ 0002.gif "/>Steps:Click on the Master book List in the top left cornerAnd then into a book catalogueAnd then find the following as shown:650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/3F/EE/wKioL1PM0-7BzovXAAF
necessary to modify the Yum source, you can useHttp://mirrors.163.com/http://mirrors.sohu.com of these 2 domestic sources.Execute the following command. Cd/etc/yum.repos.dMV Centos-base.repo Centos-base.repo.bakwget Http://mirrors.163.com/.help/CentOS-Base-163.repo or wget Http://mirrors.sohu.com/help/CentOS-Base-sohu.repoRun the Yum Makecache build cache4 Console page Some of the text on the button is garbled solution (such as login screen: Login button)Workaround:EM garbled is caused by Java,
Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows:
SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted.
No rows selectedSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release
How to export an empty table in Oracle 11g
Because of the new features created by the delay segment of Oracle 11g, Oracle does not allocate data segments when there is no data insertion, leading to exp being unable to export the empty table of the
In the 64-bit Windows 8 Enterprise Edition environment, we connected the oracle11g server for two days. We will share the process for your reference.
Local Environment:
1. SERVER: Oracle 11g R2 64-bit, installation path E:/org12
Download: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
2. Client:
(1) Instant Client, lightweight, installation path E:/oracle11/Clie
Oracle 11g EM Dbconsole reconstruction tutorial, 11 gdbconsole
Overview: You can use command lines and graphical interfaces to manage the daily management of oracle databases. command lines include commands such as sqlplus, srvctl, and crsctl, the graphic interface includes 10 Gb EM dbconsole, 11 gb em dbconsole, grid control centralized management, and EM expre
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.