Oracle

Recently encountered a number of ASM data header problems caused disk GROUP can not be normal mount, the database is not working properly, has brought endless trouble, this time thinking, if I did the ASM data header backup How good ah,

The user of the OID has some properties that are not operational, such as Authpassword, so you need to export these properties (similar to auto-generated primary keys in db) when exporting.Therefore, when OID is exported, it is important to note

If you encounter a kghstack_underflow_internal_2 error in version 11.2.0.4, you are likely to encounter bug 18687067, which was introduced in the 11.2.0.4 release. In the initial customer report of MOS, typical problems such as the following,

the difference between Oracle user and schema (original) Blog Categories:Oracle Day-to-day Management Overview The schema and user definitions are as follows A schema is a collection of the database objects (used by a user.).Schema objects are the

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start

Write in front: In the work, the general installation of Oracle oneG client, configure Net Manager (installed client or server), remote connection to the Oracle database to meet the needs of connecting the database. If you want the machine to

Tag: ROM ble operation code Sep erro Column View object[Oracle] ORA-600[KDBLKCHECKERROR]LOB Bad block handlingThe customer environment reported the following error:Ora-00600:internal error code, arguments: [Kdblkcheckerror], [2], [10388], [63068], []

Oracle's official SQL Developer comes with Oracle migration Workbench. What is Oracle SQL Developer? On the official page, this is how it is presented: Oracle SQL Developer is a free and fully supported graphical tool for database

In the previous article, using CDC (data change capture) in SSIS 2012 , describes how to use CDC in SSIS 2012, which is explained on this basis. How to implement change capture on Oracle data tables through the Attunity provided by the changes data

Because of the recent international go to Oracle on MySQL, this inevitably involves time zone and timestamp issues. Do an experiment and summarize.OracleFirst look at the definition of Oracle Concepts for timestamp:The TIMESTAMP data type is an

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start

Because it is a "top secret leaked" information, to prevent the investigation, the need for the small partners to quickly download the attached courseware document.Because the video is too large, has been placed in the Baidu network, has been in the

Does Oracle GoldenGate support extracting or replicating data from SAP HANA database to SAP HANA database?From:Does Oracle GoldenGate support Replication to/from Sap-hana Database (document ID 1413202.1)Suitable for:Oracle goldengate-version 10.4.0.1

Environment: Oracle 11.2.0.3 Requirements: Production of a table due to improper design, there is no primary key. Now you need to add the primary key, the amount of data is large, want to build in parallel.1. Direct ADD, hint ora-3001: not

1, to use PL/SQL need to install the Oracle client (this is necessary, otherwise plsql will not use, this client can go to Oracle official Web download, called instance client, as far as possible with the newer version on it, The Windows version of

Document directory 2. 1. Export data from the table to a file (using trusted connections) 2. export data from the table to a file (using Hybrid Authentication) 2. 3. Import the data in the file to the table 0. References: SQL Server BCP usage

 I. Description Oracle provides a profiler toolkit that allows you to view the performance of each module during PL/SQL Execution. You can download this script from MOS: Implementing andusing the PL/SQL profiler [ID 243755.1]   You can also download

Oracle Database Name, Instance name, database domain name, Database Service name, global database name details database name, Instance name, database domain name, Global Database Name, service name, this is a few confusing concepts for many

Working with Dates in PL/SQL (date used in PL/SQL) The previous articles in this introductory PL/SQL series focused on working with strings and numbers in PL/SQL-based applications. without a doubt, strings and numbers are important, but it is