Oracle

Oracle Data Import Export Imp/expEXP is available under the Oracle installation directory . EXE with IMP. EXE for these 2 files, they were used to perform the import and export of the database. So Oracle data import and export imp/exp is comparable

CREATE OR REPLACE FUNCTION "Ufn_split" (p_list varchar2, p_sep varchar2: = ', ') return type_split pipelined      is L_idx Pls_integer;       V_list varchar2 (4000): = P_list;       V_num number (18,0): = 1;   O_tablesplit Obj_tablesplit; Begin

Oracle under Windows, when an instance is started, it writes boot information to the Event Viewer of the Windows operating system-the application section, and this write behavior cannot be disabled with Oracle parameters or other means.If the Event

Reference: http://www.cnblogs.com/joey0210/archive/2012/09/29/2708420.html previous article on the DLL reference problem, mainly said that the program if the use of reflection, The DLL that reflects the creation of the object must be placed in the

Oracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and the IMP command can import the DMP file from a local to a distant database

--undo Table Space Summary--View all table space namesSELECT NAME from V$tablespace;--Create a new undo table space and set the auto-expand parameters;CREATE UNDO tablespace UNDOTBS2 datafile ' D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS02. DBF '

In the process of writing a Java program, how to read a field of type BLOB for an Oracle database table?Here's a workaround when I write a program. The core statement. (Transfer up to make a change, format do not learn, develop good habits)For

 1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :A the installation directory should not have Chinese and white spaceB oracle10g support winxp does not support win7,8 and vista;oracle11g supports all

method One: Use Sqlplus# # #64位: [[email protected] ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.3.0 Production on Fri Oct 318:44:05 Copyri Ght (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition release11.2.0

Installation Checklist Hardware checklistThe next update.Operating system Check list OS version support supported releases, kernels, etc. (distribution, release, kernels, and packages) for the x86-64 system Linux 6

Occasionally need to understand, study this article, reprint recordFrom: http://www.2cto.com/database/201304/206573.htmlThere are four main functions in Oracle that support regular expressions:1,regexp_like: Similar to the function of

Occasionally need to understand, study this article, reprint recordFrom: http://blog.csdn.net/jxzkin/article/details/79496291. Create test data[HTML]? View Plain Copy CREATE? TABLE? Cc?? ?? (Student?) NVARCHAR2 (2), Course? NVARCHAR2 (2)

Oracle A lot of version number, first look at the 11g version number description:Attention: after the Oracle 9.2 version, Oracle's maintenance release number is changed at the second digit bit. And before that is in the third digit digit.1. Major

theQuest Error Manager (QEM)is a framework that would help you standardize the management of errors in a pl/sql-based application. With QEM, you can register, raise and report on errors through a API that makes it easy for all developers to perform

In the Oarcle SQL script, the field length exceeds 4000 execution will have an exception, and in PostgreSQL more than 4000 can still execute normally, the product supports multiple databases, such as Oracle and PostgreSQL, when the basic data is

View the two script shares that cause Session blocking in Oracle, oraclesession User A deletes the file but does not submit the file. Copy codeThe Code is as follows:SQL> delete from test where object_id Eight rows have been deleted. If user B

SQL script sharing for viewing table space usage in Oracle, oraclesql Copy codeThe Code is as follows:/* Formatted on 14:51:13 (QP5 v5.185.11230.41888 )*/Select d. TABLESPACE_NAME,SPACE | 'M' "SUM_SPACE (M )",BLOCKS "SUM_BLOCKS ",SPACE-NVL

ORA-14450: attempt to access a transactional temp table already in use, temptable ORA-14550 errors may occur when modifying session-level temporary tables in ORACLE data, so why does the session-level global temporary table report a ORA-14450 error,

Oracle official documentation reading references We should read the official documents with a focus. Therefore, this article lists the books that are suitable for reading important documents. In actual work, we should read the relevant official

2. solutions when oracle cannot be connected to a virtual machine using a windows ClientWhen the virtual machine can connect to the local machine, but the remote connection is still unavailable, add rules in the firewall at this time: A: Log On As