Oracle

Required software: VMware Workstation Oracle-xe-univ-10.2.0.1-1.0.i386.rpm: 250 m Oracle9i310_simplified client (easy to use) Plsqldeveloper or toad   1. install Linux with Vmware (centos is preferred for Redhat UBUNTU)   2. If Oracle is

When the database is used for a period of time, sometimes the table does not have enough space. Generally, the user's quota is full, or the table space and disk space are full. In most cases, the tablespace is full. If you often view the alarm

When I tried to install Oracle 8i on Win2k with SP4, the setup program just did not startup. There seems to be a known issue: Cpuid detection for Intel. Pentium. 4 processor system:Intel has identified that applications which use the Symantec

1. Error-ORA-12514: TNS: ListenerProgramThe Service requested in the connection descriptor cannot be recognized currently If your server somehow reports this error, It was always normal before , Then try the following method ( Remember to back up

1. Invalid Number: Itself is a string format and must be converted to a string format   2. A non-numeric charactor was found where a numeric was expected: The date format is also converted to the date format.   3. Column ambiguously

In Oracle, only DML starts a transaction. That is to say, insert, update, and delete all start a transaction, and the transaction will automatically end when the commit/rollback/DDL command is executed. 1. Obtain the first few digits of a specific

1. Write BLOB: String File_name =   " D: \ 20080523.jpg " ; String Conn_str =   " Provider = oraoledb. oracle.1; Password = agoodjob; persist Security info = true; user id = AMS; Data Source = IMS; extended properties =

Oracle official reference: PL/SQL language referenc-> 9 PL/SQL trigger Reasons to use trigger: ■ Automatically generate calculated column values■ Log events■ Gather statistics on Table Access■ Modify Table data when DML statements are issued

If you do not have a Metalink account, you can use thunder to download these patches. Oracle 9208 patch: Ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip Ftp://updates.oracle.com/4547809/p4547809_92080_AXP.zip

1. SGA A. specify the maximum SGA value,Once specified, data_buffer (db_cache_size in Oracle9i) and pai_pool_size do not need to be specified. That is:If sga_max_size is set in 9i, the size of the data buffer and shared pool can be dynamically

-- Data cache hit rate -- Formula: 1-(physical reads/(db block gets + consistent gets )) -- The hit rate should be better than 0.90 Select name, Value From v $ sysstat Where name in ('physical reads', 'db block gets', 'consistent gets ') / -- Hit

Name Description Reasonable values shmmax maximum size of shared memory segment (bytes) 250kb + 8.2kb * shared_buffers + 14.2kb * max_connections or infinity shmmin

String myoraclestr = "Data Source =" + this. textbox1.text + "; user id =" + this. textbox2.text + "; Password =" + this. textbox3.text + ";";Oracleconnection conn = new oracleconnection (myoraclestr );Oraclecommand cmd = conn. createcommand ();Conn.

Today, I opened the Enterprise Manager and found that each user has two additional stored procedures: dt_dropuserobjectbyid and dt_setpropertybyid. Answers found in the itpub Forum:Http://www.itpub.net/155276.html It turned out that I directly

Oracle9i introduces the merge command, you canSQLStatement to execute the inserts and updates operations on a table at the same time. the merge command selects rows from one or more data sources to update or inserting to one or more tables. in

Distributed operations between SQL2000 and Oracle The latest project will be cascaded with the data generated by Oracle, marking: Database: our project: SQL2000 (independent server -- win2003) Customer: Oracle 9i (independent server -- win2003)

Common Oracle commands ---- load data 1. Loading data using direct_load insertSQL> insert/* + append */into EMP nologgingSQL> select * From emp_old; 2. Parallel direct-load insertSQL> alter session enable parallel DML;SQL> insert/* + parallel

Common Oracle commands-log management 1. view log filesSyntax: select Member from V $ logfile 1. Forcing log SwitchesSQL> alter system switch logfile; 2. Forcing checkpointsSQL> alter system checkpoint; 3. Adding online redo log groupsSQL>

Create Table extnl_table ( Col01 varchar2 (100 ), Col02 number, ...... )Organization external(Type oracle_loaderDefault directory "XXX"Access Parameters(Records delimited by 0x '0a' skip 1 fields terminated by', 'enabledby' "'lrtrim missing

The following code runs in Microsoft SQL Server 2000: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->-- The join keyword in SQL statements is a commonly used and incomprehensible keyword. The