Oracle

# Legal Oracle Identification symbol 1, cannot be reserved keyword 2, must use 1 to 30 characters. The name of the database is up to 8 characters. 3, must start with the letter character in the database character set 4. Can only contain

Well, I also Finon, because in the company's year-end goal of writing to learn Oracle, today began Oracle, to give you a new understanding of it! Not going to hit me! ~ Quack. Actually, to be honest, I don't want to write theory in this respect,

In the analysis of the relationship between V$tempfile and V$sort_usage, we notice that Oracle's allocation rules and regular data files are not the same for the absolute file number (AFN) of the temporary file. In fact, the absolute file number of

This technical article, provided by the International Oracle User Group (IOUG), is a user-organized organization that enhances the level of Oracle database experts and database developers by providing high-quality information, training, networking,

Database environment Leo1@leo1> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release 11.2.0.1.0-64bit Production Pl/sql Release 11.2.0.1.0

Conditions for inserting a view: 1. If the view is based on a base table, then this is called a connectionless view, and all of the disconnected views are updatable, that is, you can do it on the view, Insert,update,delete the operation. 2. If you

Oracle's spatial database operation driver updated, the new driver for Oracle8.0 or above, the new driver in the database operation above and the original driver difference is larger, but one thing: the use of simpleThe steps to build a spatial

Environment: WinXP, iReport1.2.8, Oracle 10g databaseAfter installation completes iReport1.2.8, when making database connection, the Oracle 10g database is connected by JDBC, the connection is set up as follows: The above configuration is correct,

Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most

Oracle is always different for advanced features (I hate this, if it's a product that needs to be programmed specifically for this product, and that's why I never looked at a platform like WebLogic), the big object access is set to use its own LOB

We know that user-owned role permissions are not available in stored procedures. Such as: 　　SQL> select * from dba_role_privs where grantee='SUK';　　GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE------------ ------------SUK DBA NO YESSUK CONNECT NO

Absrtact: The development of dynamic SQL program is summarized, and some development techniques are given according to the author's actual development experience. Key words: Dynamic Sql,pl/sql, high performance 1. static sqlsql and dynamic SQL

Oracle storage of large text has been a thorny issue. First, the storage database: "Defining variablesJava.sql.Connection Conn; Database Connection objectsString SQL;Long ID;ResultSet rs;Statement Stmt,stmt1;java.sql.drivermanager.registerdriver

If you use DBCA to establish a RAC database, the Remote_listener parameters are configured on each node by default, so the previous Test load_balance was tested in the presence of Remote_listener. Here is a test to remove the effect of

Odp.net 11g is an Oracle-released Ado.net component for. NET programs to access Oracle databases, better performance than Microsoft's own Oracle components, more access to the UDT (User Defined type) type, Procedure, Ref and so on advanced Oracle

To test the creation of a data guard environment on the same server. The main library is in a normal state and there are available backups, and the force logging and associated initialization parameters for the main library are set below: sql>

Use tablespace point-in-time Restore (TSPITR) to restore one or more non-system tablespaces to a point in time different from the rest of the database. This is a bit like the flashback. For example, the user mistakenly deleted 3 sheets, we can use

Oracle's Range,hash,list three major partitions Maybe we're all familiar with it, but what each partition applies to what scenario may be a lot of people's puzzles, what should be noted when choosing a different partition, why, and what needs to be

A few days ago, a friend of the group said DB in the beginning of backup mode after shutdown not come up, today said backup recovery test a bit, found that can be up, but the production environment or to pay attention, it is best not to do so. sql>

Rman backed up db when: Waiting for snapshot control file Enqueue prompt, rarely see this hint, recorded. Rman> run{ 2> backup Database; 3> Delete noprompt obsolete; 4> backup Archivelog all; 5>} Starting backup at 2011-09-30 15:31:00 Using