Oracle

Recent migration practices for Oracle to Greenplum, steps are as follows: 1. The implementation process of implementing Oracle's data structure migration to GP using ORA2PG 2. Oracle's data migration to GP implementation process 1. ORA2PG Address:

Oracle explicitly stated on its official support website in January 2013 that it does not enable VMware to run Oracle database.In the current era of virtualization rampant, how can we do it well?I have the following suggestions:1, if it is an

The entire installation of Oracle cloud control 12c is more complex, just the choice of installation path, login password, port number and many other configurations are confusing, dizzying. This article describes how to get installed after the

Oracle's support strategy for its products is difficult for most people to figure out, for Oracle Database 11g support cycle, a lot of friends have raised objections, refer to some of the documents mentioned below, I hope to help you understand

Today is 2014-08-19, I received csdn to send me the application of blog experts invited, I feel really ashamed ah. I haven't had the energy to write something since I changed my job. Today, a colleague of mine posted a packet of data pairs in the

One, automatic workload library (Automatic Workload Repository,awr)The Automated Workload library (Automatic Workload repository,awr) is a tool provided by Oracle Corporation. AWR can automatically collect, process, and save performance statistics,

Java Oracle thin and OCI connectivity for failover of multiple databasesFirst, Thin wayWhere the URL isjdbc:oracle:thin:@ (description= (Load_balance=on)(Address= (PROTOCOL=TCP) (host=127.0.0.1) (port=1521))(Address= (PROTOCOL=TCP) (host=10.132.111.1

Experimental environment: RHEL 6.4 + Oracle 11.2.0.3Experiment: The online redefinition of the normal table as a partitioned table, including the primary key corresponding to the index is transformed into a partitioned index.1, construct ordinary

2014-07-26 BaoxinjianI. Basic concepts of Oracle Architecture 1. Oracle's overall architecture is divided into three parts The first part: System Global Area (SGA) Part Two: program Global zone and background process Part III:

The analysis of CLOB type processing in the original Broken Sword ice-oraclePrevious analysis: ORA-01461: Can only bind a long value to insert a long columnMost recently, for the Clob field, when inserting data, the number of bytes in the character (

Http://www.cnblogs.com/pan11jing/archive/2009/12/02/1615021.htmlCREATE TABLE t_bi_currentaccountdetailed(OrderDate DATE,Branchflag VARCHAR2 (3),SortId VARCHAR2 (11),OrderNo VARCHAR2 (15),CustomerId VARCHAR2 (11),Amtofdebitside number (14,2) DEFAULT 0

Test environment: Oracle Enterprise Linux 5.8 64-bit virtual machine installed in VMware Workstation v9.0.2 softwareInstallation software: jdk-7u40-linux-x64.rpm+apache-tomcat-7.0.53.tar.gzInstallation instructions: Download jdk-7u40-linux-x64.rpm

Using the SQL SERVER2005 Export tool, the data export table to Oracle, the table name to see the table, but the query or delete prompt "ORA-00942 table or try not to exist" error, the internet to check a bit, is the following reasons:"When you query

Normally, connecting Oracle with PL/SQL developer requires the installation of Oracle client software, which means that your hard drive will take up about 1g-2g of space, and you will have some more boot-enabled services for the Windows operating

Today is 2014-05-27, today encountered a Lib problem, record again. This is a case, but also a way to solve the problem of the process.When we use Sqlplus to log in to a UNIX database, there is a possibility of a similar problem: xxxxxx bad ELF

When you recently used the Oraclede IMPDP tool to import a database, the following occurs when using the database.[null] [17081]; Error in batch: Ora-00001 is java.sql.BatchUpdateException: Error occurred in batch: Ora- 00001 -(:155)Because the ID

SapMeaning:First, SAP is the company name, the SAP company, which was founded in 1972 and headquartered in GermanySecond, SAP is the name of its ERP (Enterprise-wide Resource planning) software, the world's first ERP softwareOracl ERP compared to

After a few years of Oracle's book, I have a little experience with different books. Many friends let me recommend some Oracle books, below I will say my opinion.In fact, at different stages, different books will have different effects on you,

OraceleTimesten connects to DSN to create a user 1. Enable startup [Tt @ host2 info] $ ttDaemonAdmin-start-force /Home/tt/TimesTen/tt1122/info/timestend. pid file exists, attempt start due to-force option. TimesTen Daemon startup OK. 2. Add the test

Oracle static registration and dynamic registration details, oracle static I. Overview: Oracle registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs