oracle 11g end of support

Flashback is based on the content in the undo segment. Therefore, due to the undo_retenton parameter, to use the flashback feature, you must enable automatic tablespace revocation. Oracle flashback data archive (FDA) is a new feature in Oracle11g. By storing changed data to another created flashback archive ), different from undo, you can set a separate storage policy so that it can return to the old data before the specified time without affecting th

Configure Oracle 11g Green client and PLSQL environmentThis approach is done by using the Oracle-provided lite client, which is a green, free-to-install client. There are many versions of the Instant client: primarily basic and basic Lite. The basic version includes all of the files that support running OCI, OCCI, JDBC

Tags: Oracle 11gTest environment: Win7 64-bit flagship +JDK7 (64-bit) Installed software: Oracle 11g R2 64-bit Follow the online general tutorial installation completed database, found a bunch of problems, close up this note. 1, using SQL Developer login, error: Because the system is prompted to find Sqldeveloper.bat this file, I began to think that the system i

Tags: 11g oracle 11g Database1.2.4, Database schema1, three level mode(1), Concept modeAlso called pattern, is a description of the logical structure of the global data in the database, is the public view of the whole user. It mainly describes the concept record type of the data and its relationship, and also includes some semantic constraints between the data, a

Tags: style io strong ar for art SP on CBefore Oracle 11g it was a bit of a hassle, after 11g, it was very simple. Now has the function business is, has a test table records is the document approval information, the ID is the approval information primary key, SHEET_ID is the foreign key, is the document Id,remark for approves the content, on the front-

The installation process (the main process is to copy someone else's tutorial directly) and questions:1. Update the system to the latest :sudo apt-get updatesudo apt-get dist-upgrade2. If you are using Ubuntu that is not a desktop version (such as Ubuntu Server), you need to install a desktop program because the graphical interface is required for Oracle installation:sudo apt-get install Gnome-coreBelieve that a lot of the use of the desktop version,

: Database version is 11g Operation user must have SYSDBA permission Database parameter timed_statistics must be true IO must be allowed asynchronously, but with the file system, you can set the Filesystemio_options parameter to SetAll Ensure that the data file allows asynchronous IO, which can be confirmed by the following SQL statement: COL NAME FORMAT A50 SELECT name,asynch_iofrom v$datafile f,v$iostat_file I WHERE

.'); 11 END; 12 13 INSERT INTO READ_ONLY_TABLE 14 VALUES (1); Run this script and you will get the error message: ORA-20001, Table is read only table. 2-check Constraints Use the following SQL statement: 1 CREATE TABLE READ_ONLY_TABLE2 (COL1 NUMBER); 2 3 ALTER TABLE READ_ONLY_TABLE2 ADD CONSTRAINT READ_ONLY_CONST CHECK(0=

In a new environment, the company needs to install RHEL (Red Hat EnterPrise Linux, the same below) 5.5 64-bit and Oracle 11g 64-bit in a virtual machine environment, so it has been tossing for three days, the pain, only the person who knows. Here, let's keep a note of the process, hoping that others will take less detours. First, on the virtual machine selection, the options are as follows: (1) The advantag

"title=" Image038.png "alt=" Wkiol1stzndihgzyaajjby1iatw467.jpg "/>Tip You are currently required to continue with the following script after the root user has executed these scripts until the final prompt for installation is complete.650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/2D/wKioL1STzOyhfR9vAAHBx7LfVVA350.jpg "style=" float: none; "title=" Image039.png "alt=" Wkiol1stzoyhfr9vaahbx7lfvva350.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/30/wKiom1STzE

, understand. http://victorwmh.iteye.com/blog/1074854 real change. Bash_profile in accordance with this 3rd kind of change, remember to change the end to let it take effect. My path is in/u01/oracle/product/orahome/bin. OK, netca command, enter NETCA carriage return. and the error: Oracle Net Services Configuration: Xlib:connection to ': 0.0 ' refused b

should now is able to test the forward and reverse lookups using the "nslookup" command. The output below shows the forward and reverse lookups of the SCAN address.# nslookup Rac-scan.localdomainserver:192.168.0.4address:192.168.0.4#53Name:rac-scan.localdomainaddress:192.168.0.121Name:rac-scan.localdomainaddress:192.168.0.122Name:rac-scan.localdomainAddress:192.168.0.123# nslookup 192.168.0.121server:192.168.0.4address:192.168.0.4#53121.0.168.192.in-addr.arpa name = Rac-scan.localdomain.# nsloo

Tags: creat altered end local including name AC file createdsql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/SYSAUX01.DBF ' resize 2048M;Database altered.sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/SYSTEM01.DBF ' resize 2048M;Database altered.sql> ALTER DATABASE tempfile '/U01/APP/ORACLE/ORADAT

1. Preparations for configuration in Linux Environment: Linux: RedHat Enterprise 5.4, DB: Oracle 11g R2 X64, Oracle installed in the/home/oralce_11 directory. The configuration process is as follows: (most of the content is online, and individuals follow the online steps) 1) Check the basic requirements (this must meet the requirements for the awesome server and

Label: Before 11g, when the data volume of the table was changed beyond 10% of the total amount of data, the statistics were collected at the end of the night. How to infer 10%. Previous posts have been researched: the principles and experiments of Oracle's own active statistics collection. This stale_percent=10% can not be changed, assuming that the table is very large. 10% is a lot of data that is likely

Oracle 11g R2 installation tutorial, oracle11g I, Note that Oracle is divided into two files. After downloading, extract the two files to the same directory. In the path name, it is best not to show Chinese characters or irregular characters such as spaces. Official Address: Beijing. Win 32-bit operating system: http://download.oracle.com/otn/nt/oracle11g/112010/

indicates that when the tablespace size is not sufficient, it will automatically expand, all the recommendations plus the autoextend on parameter.To delete a table space:drop tablespace ittbank including contents and datafiles;Modify table space Size (Note: Modify = can be increased and can be reduced.) ）alter database datafile ‘/u01/app/oracle/oradata/ORCL/ittbank.dbf‘ resize 200m;Increase table space Size (Note: increase = can only increase, cannot

Label:During the installation of Oracle 11g R2, this error occurred while creating a new DB instance, and if you select Ignore, a ora-28000 error occurs. Through the network query verification, this is the first configuration of the administrator password, the use of the beginning of the password, Oracle does not seem to supp