Oracle

The dba_free_space shows a tablespace with free space, and if a tablespace is not contiguous, then there is a record in dba_free_space for each space. If a tablespace has several records indicating that the tablespace is fragmented, the tablespace

Original blog: http://blog.itpub.net/519536/viewspace-614893/Today, in the process of deploying a set of 10g Oracle (10.2.0.3 versions), ora-00600:internal error code, arguments: [Keltnfy-ldminit], [46], [1], [], [], [], [ ], [] error.Take this

Reference article:Http://blog.chinaunix.net/uid-26446098-id-3344813.htmlThe error message is as follows:From the wrong angle can be introduced: it should be insufficient table spaceDepending on the usage of the view tablespace, the command is as

I. Modification of/ETC/ORATAB#orcl:/u01/app/oracle/product/11gr2:norcl:/u01/app/oracle/product/11gr2:y change "N" to "Y"Second, modify the/u01/app/oracle/product/11gr2/bin directory Dbstart and DbshutRemove a commentOratab=/etc/oratabChange

Oracle DB allows external tables to be queried in read-only form. The external table can be stored in any storage device that can be read by Oracle DB, its contents are not saved in db, the DB only saves external table metadata,db can query (join,

Stones installation of OracleDatabase: is to put some records or call items, in the database application or software to manage. What are the benefits of such management? It can quickly retrieve a certain bar!Our common Excel can be seen as a simple

From a library user UA guide data to B library user UB1. ExportEXPDP ua/[email protected]/orcl schemas=ua directory=data_pump_dir dumpfile=ua.dmp logfile=ua.logSchemas the list of scenarios to export, unspecified Shime considers the current logged

Previously used Oracle+extjs for project development, may have little contact with the SQL Server database is similar,As far as I am concerned, many projects are generally based on the ado.net+sqlserver2008 R2 (The Used Entity Framework (ORM)

Look at a SQLSelectQ.*, R.goods_name from(SelectNVL (T.goods_code, S.goods_code) Goods_code, T.buy_open_price, T.buy_position_price, T.buy_position_amount, S.sale_open_price, S.sale_position_price, S.sale _position_amount, (NVL

The core is the following two statements, tested Redhat 5 and Redhat 6, the statement of B C D for the SDB SDC SDD, etc., to be modified according to the actual situationRedhat 5For i in B c D E F g h i j k l m n o p; --Make adjustments according to

I. Description of the official websitehttp://download.oracle.com/docs/cd/E11882_01/server.112/e26088/functions088.htm#SQLRF00658PurposeThe length Functionsreturn the length of char. Length calculates length usingcharacters as defined by the input

This article will show you how to generate a new collection and add data to it if you need to.Procedure Insert_object (d in Dept_array, D2 out Dept_array) isBegin --first to insert the data into a new array. SELECT CAST (MULTISET

Create tablespace dsxzfw datafile ' D:\yangk\oraclespace\DSXZFW.ora ' size 1000m; Create a tablespace, and note that if you want to restore the database, the tablespace name must be the same as the space name at the time of backup (that is, the

An Oracle Database knows a table and queries a table with a primary foreign key relationship. -- Check whether the foreign key table NC56.CSCI has a corresponding primary key table SELECT. owner,. TABLE_NAME primary_table_name,. CONSTRAINT_NAME

Oracle (4) --) Advanced subquery ~) This section will discuss the more complex application of instant queries, mainly to simplify SQL and improve performance from the aspect, of course .. There are many ways to improve performance .. Today I

ORA-00911: invalid character Error, I usually use pl SQL and golden32 to query database software. If I use golden32, it is no problem to alias it as Chinese when I use it. Until I want to convert PL SQL (use Chinese package chinese.exe ), after the

ORACLE Stored Procedure Prelude: 1: A Necessary concept: ORACLE provides the ability to store PL/SQL programs in databases and run them anywhere. In this way, stored procedures or functions are called. Procedures and functions are collectively

Oracle cursor: Query and print employee name and salary -- Query and print employee name and salary -- set serveroutput on/* 1. cursor attribute % found: true if the record is obtained; otherwise false; % notfound: */declare -- Define a cursor cemp

[Oracle] RAC shared storage udevThe core lies in the following two statements. The redhat 5 and redhat 6 are tested. The B c d in the statement represents sdb sdc sdd, which should be modified according to the actual situation.Redhat 5For I in B c d

[01] Oracle Database introduction, 01oracle database Introduction Oracle relational database: built on the relational model. Oracle10g: g (grid) Grid technology. grid Computing connects a large number of computers through network sharing and