Oracle

Oracle local net service name configuration tnsnames. ora file has strict format requirements Today, a service name is manually added to the configuration file. When a client is connected, the SERVICE_NAME resolution error is reported.

　 Procedures and functions Both the process and function are stored in the database in the form of compilation. The function can have either no parameter or multiple parameters and return a value. The process has zero or multiple parameters and no

SQL * loader is a tool used to import external data from Oracle databases. it is similar to the load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading. How to use SQL * LoaderWe can use

Differences between Oracle and MySQL 1.In Oracle, select * From all_users is used to display all users, while the command for displaying all databases in MySQL is showDatabases. For my understanding, an oracle project should have a user and a

  Oracle logical database structure Overview Database space allocation units:Data Block, extent, and segment).   Specific concepts can be seen: http://hi.baidu.com/feixianxxx/blog/item/8d5429028d05dc091d95838a.html   I want to write a fewNotes:   1.

Hardware requirements[# Root @ sun10g/] #/usr/sbin/prtconf | grep "memory size" Memory size: 1024 megabytes[# Root @ sun10g/] #[# Root @ sun10g/] #/usr/sbin/swap-S Total: 159060 K Bytes allocated + 26872 K reserved = 185932 K used, 2167140 K

Many people think that Oracle can easily change the password, but it cannot change the username. In fact, the name can also be changed, but it is a bit difficult to change.  Use of username change As for the usefulness of name change, it is very

The answer here is not comprehensive. These questions can be explained from multiple perspectives. Maybe you don't have to give a full answer during the interview, you only need to answer your questions to familiarize the interview examiner with

10 Gb database Introduction: more new optimizer hints can be used to control optimization behavior. Now let's quickly parse these powerful new hints: Spread_min_analysis With this hint, you can ignore the Compilation Time Optimization rules for

Quick query of Oracle function list 2004-10-20 22:53:13  PL/SQL single-row functions and group functionsA function is a program with zero or multiple parameters and a return value. Oracle has a series of

I. Oracle connection method: Starting with a user request,What is the complete working mechanism of Oracle? First, a user process sends a connection request, if the host name or host name hit by the local service is used ), the request will be

Difference between after and before:One is triggered before the record operation, and the other is triggered after the record operation. For example, a foreign key is defined between tables. When deleting a primary key, you must first Delete the

Memory Structure of the database:Memory structures are allocated to the Oracle instance when the instance is started.The two major memory structures are known as the system global area (also called the sharedGlobal Area) and the program global area (

Select aru_release_name | '.' | minor_version | '.' | tape_version version, Row_source_comments memo, Base_release_flag From ad_releases ---------------------------------------------------11i. 5.10.2 created by snapshot-preseeding SQL script n11i. 5.

-- Conventional load mode---- Load. CTL FileLoad dataInfile 'C: \ 1.txt'Into Table DeptFields terminated ','(Deptno, dname, Loc) ---- The data is as follows:10, sales, Virginia20, accounting, Virginia30, consulting, Virginia40, finance, Virginia ----

  1 Definition   Oracle Bad blocks can be divided into physical and logical Bad blocks. The damaged block information is similar:ORA-01578: Oracle data block upted (file #6, block #11)ORA-01110: data file 6:

Many people, especially those who do not like Oracle, must learn from Oracle and think that Oracle occupies a lot of memory.I really don't like installing oracle on a physical machine. Most of them are Windows users, and most of them are

Oracle Database Configuration modification:C:/Oracle/product/10.2.0/db_1/Network/admin/listener. ora C:/Oracle/product/10.2.0/db_1/Network/admin/tnsnames. ora   Oracle Database listening program cannot start the solution: C: /Documents and

Create a classPackage cn.com. CNPC. tz. tetd. workflow;Import java. SQL .*;Import cn.com. CNPC. tz. tetd. Common. notes;Import java. SQL. connection;Public class test{Public test (){Try {Jbinit ();} Catch (exception ex ){Ex. printstacktrace

In the dedicated connection mode, the server establishes a connection with the client for every client request to connect to the database server. This connection is used to process all requests of the client, until the user actively disconnects or