Oracle

This post is transferred from Http://bbs.pgsqldb.com, and two posts are joined together. A lot of content is online search information, I just tidy up, there are missing places, welcome to add First Use tool (ORA2PG) to automatically

Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the

Test tools for WSDL-based Web services I've seen these tools: the best is the soap UI, The second is to use WebServiceStudio.exe, and fiddler4setup.exe (this tool is very powerful, HTTP GET or post and webservice can be measured, very suitable for

Turn from: http://blog.csdn.net/magicboylinw/article/details/7025885 First, download Download Address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html This is the download page for Oracle Instant client, and

, the 11.2.0.1 RAC that is installed on the virtual machine is chosen 11.2.0.1 because of problems with public IP and private network segments. During the installation instance, the computer crashes and restarts, and CRS fails to start. [Root@rac1

Recently do a Java EE project, the need to implement the JSP page upload and download files. A long time ago that JDBC support for large objects (LOB) access, think it is easy to do to find a lot of problems, read a lot of articles, but there is no

A few days to have nothing to do, just tidy up the next imp/exp IMP/EXP is an Oracle Import Export command that can be used as a migration of data, EXPDP/IMDP is also a command for Oracle data Import export, and is more efficient than imp/exp, which

Experience Summary: The online logs are divided into current and non current online logs, and the corruption of the non-current online log is relatively simple, and the problem can be resolved by the clear command. Corrupt non-current online log:1,

First, the question:Yesterday I want to modify a table in the Oracle database a field, found how the changes are not successful!!! and gives the following tips:　　ORA-54031: The column to be deleted or modified is used by a virtual column

Http://www.dataguru.cn/thread-171156-1-1.htmlGoldengate several important processes introduced:1. The manager management process opens at both ends, monitors and restarts other processes, allocates data storage and reports errors and events;2,

--Enter CDBSqlplus/nologConn Sys/sys as dBA--View Database basic informationSelect name,cdb from V$database;--View information about the containerSelect Con_id,name from V$containers;--View the path to the data fileSelect Con_id,file_name from

1,oracle architecture, process management, and structural components in detailUser process: A process that connects to a database server through which the user interacts with the database. However, the user process cannot interact directly with the

Operating system version: Windows Server 2012R2Database version: Oracle 11.2.0.1Problem Description: A Windows Server 2012R2 built on a VMware virtual machine, and then the Oracle 11.2.0.1 installed on Windows SERVER2012R2, would have wanted to test

New Features of Oracle 11g (36 in total) I. Database Management ·1. Database Replay) This feature can capture the load of the entire data and pass it to a test database created from the backup or standby database, and then repeat the load to

The password file of Oracle is located in the $ ORACLE_HOME/DBS directory. The naming rule is orapw . If sid = linuxdb, the file name is orapwlinuxdb. The file is encrypted, if you use the text editing tool to open it, you will see Garbled

OracleDate type and related functions in OracleProvides many built-in date types, including the following:DateTimestampTimestamp with Time ZoneTimestamp with local time zoneInterval year to monthInterval day to second The date type is used to store

From: http://blog.csdn.net/imasmallbird/archive/2008/11/20/3340547.aspx I completed this task today and made a summary.   First, create a partition table.   Create Table mals_nm_cpu_info_t_new(Host_ip varchar2 (40 byte) not null,Host_name varchar2 (1

Oracle default port list Oracle HTTP Server listen port/Oracle HTTP Server Port 80 Oracle Application Server Edit httpd. conf and restart OHS

Step tutorial on installing Oracle 12c Release Database in win10, win1012c Install Oracle 12c Release Database in win10 In general, download and decompress the package and go to the official website. Double-click to start installation.

2017100001124.pdf use seed_database.dfband seed_database.ctlto create a database .txt manually, Using seed_database.dfband seed_database.ctlto create a database .txt-- // Read the post of yueli34 yesterday at