Oracle

Error 2304 when importing DMP file into local database using IMP statement IMP-00017: The following statement failed due to ORACLE error 2304: CREATE TYPE "T_varray" TIMESTAMP ' 2015-03-09:12:18:54 ' OID ' 0da828a87913400f93b12ebdc75afcf5 ' is

unlock accounts: Alter user account unlock Login sys User: Sqlplus/as sysdba Modify SYS User: ALTER user sys identify by password Modify SYSTEM User: Alter user system identified by Data export:  1 completely export database test, user Name

The 2-table field VARCHAR2 (4000) Now expands the length, but continues to expand the error, which has reached the maximum length of the VARCHAR2, so the plan will need to change from varchar2 to blob; Current 2-table field types ALTER TABLE

1 Terminology Interpretation and agreement Tablespace (tablespace): Provides a logical structure for the use of space for a database, and its corresponding physical structure is a data file, and a table space can contain multiple data files. Local

The previous period was a select last_number-1 from user_sequences where sequence_name= ' sequence name '. This method is a hidden problem. Error values may occur when there is a large number of concurrent access inserts. A new method was found

Oracle TNS Brief What is TNS?TNS is part of Oracle NET, dedicated to managing and configuring Oracle databases and client connections, and in most cases the client and the database must be configured with TNS, and of course, in a few cases, the

Single-record functions in SQL1.ASCIIReturns the decimal number corresponding to the specified character;Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual; A A ZERO space--------- --------- --------- ---------6

1. Develop form in Formbuilder -> download the template from the server's following path $au_top/forms/us: TEMPLATE.FMB, and change the template name to STUDENTS.FMB -> download all files of the resource folder in the server $au_top directory ->

This describes the 9i and above version of the situation, the environment for the WINDOWS2003 Oracle 10G R2.Using initialization parameter Utl_file_dir to set and resolve file reads and writes is a cliché and inflexible approach.New is the use of

Weather hot, weekend at home knocking code found a strange SQL, when using the LEFT JOIN table to join the left-hand query, a-B, before a-table row a good order, suddenly confused, the first line of records ran to the last, the descending order into

InStr (Title, ' Handbook ') >0 equivalent to title like '% manual% ' InStr (Title, ' Handbook ') =1 equivalent to the title like ' Manual% ' InStr (Title, ' Handbook ') =0 equivalent to title not like '% manual% ' There are nearly 11 million data

First, say the question In the development process, you encounter situations where Oracle DDL statements and DML statements need to be handled in one transaction, either successfully or fail. For this problem, databases such as SQL Server can be

The most recent need is to use the Oracle Job, the past is now unfamiliar, or ready to tidy up the knowledge to stay, the following is a backup SMS Log Job processing process. Part One: simply create a task 1. Create a stored procedure Create

Today, someone suggested that Dblink's suffix domain name is very unsightly regress. Rdbms. DEV. US. Oracle.com, in fact, I also think is, but there has been no power to search how to solve, today, people said, this is the task, work, so I searched

1, Long data type is stored in variable-length strings, the maximum length limit is 2GB. 2, for more than a certain length of text, the basic only long type to store, the data dictionary many objects are defined in a long to store. 1, Long data

Note: At the request of the general public, there are pictures to see the original address: http://blog.csdn.net/meteorlwj/article/details/6949096 Prerequisites:1) Install Oracle ODI2 Install Oracle XE database3 CREATE DATABASE user Odi/apps,

ASMM Automatic shared memory management: Automatically adjusts to workload changes Maximize Memory utilization Helps to eliminate Out-of-memory errors Sys@prod>show parameter SGA NAME TYPE VALUE------------------------------------ ----------- ------

Use of Logminer =========================================================== Author: Tolywang (http://tolywang.itpub.net) Published in: 2005.01.19 11:03 Category: Oracle database Management Source: http://tolywang.itpub.net/post/48/14593 -------------

C # Connect Oracle database Strings "Turn" http://developer.51cto.com/art/200908/145365.htm C # Connect Oracle database Strings (query data) -----------------------------------------------------------------------------------------------------------

In the Oracle database, the body that actually executes the SQL statement is the server process (the server process), which is the client's shadow process, acting as a discretionary proxy and executing the client's request.The server process