oca 11g

Issue: ORACLE 11g exports a user's own table with the EXP command export and IMP imports 10g found empty table cannot be exportedCause: 11g When you start to build a table, segment is not assigned by default to save space, and when the table inserts the first data, it is redistributed segmentWorkaround 3 ways:1: Insert a piece of data into the blank, and then delete it, allocate space (the empty table is re

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, and its description can be defined by the DDL

Label:First, the appearance of symptoms 1, using Sqlplus connection Normal 2, C # Use 10g odp.net connection, report the above error Second, the reason 1, oracle11g before the password is case-insensitive, starting from 11G default password case-sensitive 2, the use of 10G odp.net, will automatically convert the password into uppercase Iii. Solutions 1. Enclose the password in the connection string with quotation marks so that the password does not tu

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-end list page, wants to see this document all approval i

://img1.51cto.com/attachment/201405/16/665690_ 14002507119ka6.jpg "" 725 "height=" 544 "/> 14) as shown, select IgnoreAll (make sure the package that is ignored has all been successfully installed), click Next. 650) this.width=650; "title=" 05-014 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" 05-014 "src=" http://img1.51cto.com/attachment/201405/16/665690_ 1400250713x1w

=" A18.png "alt=" Wkiom1yto7karfefaafiph9sdx4837.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/74/E0/wKioL1Yto-PSYIvFAAHacvYcH4Q981.jpg "style=" float: none; "title=" A19.png "alt=" Wkiol1yto-psyivfaahacvych4q981.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/74/E0/wKioL1Yto-OR9rveAAIsLeQguGY016.jpg "style=" float: none; "title=" A20.png "alt=" Wkiol1yto-or9rveaaisleqgugy016.jpg "/>After waiting for 35, the database is complete, then test it:Simple validati

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 the Oracle Hom and OCI Libaray. To enter PL/SQL

by the system after the user's operation, so there is no need to adjust the temporary table space, but when the concurrent users are very much and the operation is more complex, There may be a shortage of temporary table space. At this point, the database administrator can add temporary files to increase the temporary table space.If you need to add temporary files, you can use the Add tempfile clause.If you need to modify the size of the temporary file, you can use the Resize keyword.You can al

-Firewall-1-INPUT -m state –state NEW -m udp -p udp –dport 177 -j ACCEPT :wq! #Save exit Service iptables restart #restart Gdm-restart #restart Shutdown -r now #restart the system Second, install Xmanager on the Windows client system 1. Download and install Xmanager Enterprise 3 Http://www.onlinedown.net/soft/32684.htm #英语原版 Http://www.downxia.com/downinfo/19164.html #汉化包 2. After downloading the installation software, open Xmanager Enterprise 3, then open Xbrowser, as shown below: I

Oracle 11g-oracle Startup and shutdownTarget:1. Understand the sequence of reading parameter files in oracle-11g startup;2. understand four states of Oracle;3. Master the method of State transformation. 1. Read the parameter file in startup9i before, only static parameter file Pfile file;9 I started with the introduction of the dynamic parameter file SPFile file. 11g