Oracle

The 10 Gb archive log of Oracle Database is stored in flash_recovery_area by default, and 1 GB is selected during the default installation. When the archiving log exceeds 1 GB, the space is insufficient, so the archive log file cannot be archived.

Use PL/SQL to connect to Oracle without installing the Oracle client 1. Download a software named Instant Client package from the Oracle website. This software does not need to be installed and can be used as long as it is decompressed. :

1. String concatenation Update tbl_main d set D. area_id = '0' | D. area_id 2. Stored Procedure and cursor Create or replace procedure prc_inset_dealAsBeginDeclareCursor main_departIsSelect * From main_bak;Temp main_bak % rowtype;BeginOpen

Many people have explained this online, the relevant code is also a lot, the code reference http://hi.baidu.com/bailang3106/item/c80b0fed8a08dbd1ea34c952 Http://baser.blog.51cto.com/4153192/871086   There is only one recipient process:  Create or

After the Oracle database is installed, Scott and other users are locked by default and cannot log on to the database using Scott. To unlock a user, you need to enter sqlplus and execute the following command: 1: SQL> ALTER USER username ACCOUNT

Oracle Database 10GRelease 2 (10.2.0.1.0)Enterprise/Standard Edition for Microsoft Windows (32-bit) Thank you for accepting the OTN License Agreement; you may now download this software.

Research on spatial GIS data uploading methods in Oracle Spatial)   Source: http://blog.sina.com.cn/s/reader_45f260910100999x.html     Abstract: Oracle Spatial is used to store and manage spatial data, it is easy to solve problems in data sharing,

Oracle oo4o Recently, this project is VB.net and Oracle. Because of the customer's requirements, Oracle provides oo4o instead of traditional ODBC. The full name is Oracle Objects for OLE (oo4o ). According to Japanese data, this is the most

Exp parameter descriptionKeyword description (default) keyword description (default)--------------------------------------------------------------------------Userid username/password full export the entire file (N)Buffer data buffer size owner User

Constraints:It is used to ensure that database data meets specific business rules.Restrictions in Oracle include:Not NULL:Unique:Primary Key: PKForeign key: FKCheck:A. Not NULL: non-null constraint:If not null is defined in a column, data must be

Three default accounts:Sys change_on_install Network Administrator [as sysdba] system manage local administrator Scott tiger superuser Create users, authorize and revoke permissionsLog on to Oracle: sqlplus/As sysdba to start listening: LSNRCTL

-- Do not mix up the sequence... -- 1. Create a tablespace --Create tablespace sfwebloggingdatafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ sfweb. DBF 'size 32 m autoextend on next 32 m maxsize 2048 mextent management local; -- 2. create

  Cursor XX (a, B, c...) is SQL statementBegin Open xx;LoopFetch XX into A, B, C...Spell stringExit when XX % notfound;End loop;Close xx;   Bytes --------------------------------------------------------------------------------------------------------

Technorati label: Oracle Oracle uses utl_file packageCreate or replace procedure loadfiledata (p_path varchar2, p_filename varchar2) isV_filehandle utl_file.file_type; -- defines a file handle.V_text varchar2 (100); -- stores textV_name test. name %

Install Ubuntu 10.10on Windows 7. download and run wubi.exe to install the software on any disk. Install oracle in Ubuntu... Hard work! But it's okay! I found a lot of information and made a lot of detours. The summary is as follows: First,

Log Files, also known as redo log files, record user changes to the database and can be used for database recovery. In practical applications, log file images are generally used. If one of the log files is damaged, log files of other images can also

A control file is a binary file that is automatically created when a database is created. It is used to record the database name, creation time, tablespace name, data file, and log file location. The control file is very important to the database.

I. control file backup When the database structure changes, immediately back up the control file. Once the control file fails, you can use backup to restore it. There are two backup control file methods: 1. Copy directly Example: SQL> alter Database

Alter any cluster: modify the permissions of any clusterAlter any indexAlter any role Modify permissions of any roleAlter any sequenceAlter any SnapshotAlter any tableAlter any trigger Alter cluster Modify permissions on clustersAlter Database:

Document directory Oracle SQL-sorting ting one row of several columns into one column of several rows Display Oracle SQL output rows on one single line Oracle SQL-sorting ting one row of several columns into one column of several rows Oracle