Oracle

Some time ago, I encountered a lot of problems when I installed oralce10g using the Windows 7 operating system. I found a variety of information on the Internet, and some said that the configuration files of the installation files were changed, and

Your database may already have the Scott/tiger schema. Classic installation usually includes this mode, but does not require the database to have this component. The Scott example mode can be installed under any database account. Using the Scott

Now, the computer is installed with Oracle10g.   First, make it clear that if the computer is not added to the domain, then the installation of Oracle10g is quite smooth. (My ThinkPad E40 was successfully installed)   During the installation

Sqlldr is not detailed here. I usually write data to Oracle and suddenly think of MySQL? Is there any plug-in similar to sqlldr? I did not find the plug-in, but the MySQL operation is relatively simple. Just import the file directly on the

Author: eygleSource: http://www.eygle.com/blogDate: June 26,200 5Link: http://www.eygle.com/archives/2005/06/oracleeaoieiear.html «Use of new features of Oracle9i flashback query to recover and accidentally delete data | blog homepage | popular

SQL * loader is a tool used to import external data from Oracle databases. it is similar to the load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading. How to use SQL * LoaderWe can use

Install Perl in UNIX and support Oracle databases CD perl-5.6.1Rm-F config. Sh policy. ShSh configure-D (select the default installation)MakeMake TestMake install CD DBI-1.13# Perl makefile. pl# Make# Make Test# Make install# Tar-xvf DBD-Oracle-1.0

This section describes how to use the alter table statement to modify a table. The alter table statement can execute the following tasks: 1. Add, modify, or delete Columns 2. add or delete Constraints 3. enable or disable Constraints 1. Add a column

  Oracle logical database structure Overview Database space allocation units:Data Block, extent, and segment).   Specific concepts can be seen: http://hi.baidu.com/feixianxxx/blog/item/8d5429028d05dc091d95838a.html   I want to write a fewNotes:   1.

Many people think that Oracle can easily change the password, but it cannot change the username. In fact, the name can also be changed, but it is a bit difficult to change.  Use of username change As for the usefulness of name change, it is very

Http://www2.ccw.com.cn/02/0224/c/0224c05_1.asp Character Set problems during Oracle Data dumping Wang quanhai, Northeastern University, Qinhuangdao Branch As an Oracle database user, there is no stranger to the export and import commands,

There are two ways to manage the 10g 　　 1. Oracle Enterprise Manager 2. Command Line 　　 You can enable and disable Enterprise Manager, restart various as compoment, and modify them in various configuration files. 　　 It monitors and manages data

View the relationship between the user and the default tablespace.Select username, default_tablespace from dba_users; 1. view the table structure: DESC table name 2. view the table of the current user: SelectTable_nameFromUser_tables; 3. view

The syntax for implementing update Association update in SQL Server and Oracle is different. You can use inline view (embedded view)In general, sqlserver is simpler. The test example is as follows: Create Table tmp_a(Cpcode varchar2 (10 ),Sb_ym

Errors encountered during Oracle usage and PLSQL script debugging and solutions. Update constantly...           ORA-20000 to solve the problem:   ORA-20000: Because of overflow, the general method is to set a value larger. Set long 10000;

  This error may occur when Oracle exports a database using Exp:   Encountering errors in export logfileEXP-00008: Oracle Error # encountered.ORA-01455: Converting column overflows integer datatype   This error is not reported when the parameter

Demonstration classes that demonstrate situations in which JDBC accesses Oracle large data objects lob Import java. Io .*;Import java. util .*;Import java. SQL .*; Public class lobpros{ /*** Oracle driver*/Private Static final string driver =

This article is well written. I have made it very clear about the Oracle background principles. The 10 Gb I have installed on a virtual machine is the most common problem that clients cannot connect to the server, I have benefited a lot from this

Article 1 Oracle Architecture Overview Let's take a look at a picture.  This figure shows the architecture of Oracle 9i. It looks complicated. Yes, yes. Now let's take a look:I. Databases, tablespaces, and data files1. DatabaseA database is a

Many people who are familiar with Oracle usually encounter various questions when starting to use the Informix Database: Informix is not supported, and Informix does not have this function? In fact, many times Informix is implemented in different