Oracle

sp2-0734: Unknown command opening ' imp ignored remaining row default category It should be executed at the DOS command prompt at CMD, not inside the sqlplus ... But the format must be similar to the following: Imp Personnel_manage/mwq@dbsql

Database versionOracle-> 11g @xifenfei:/home/oracle$sqlplus/as sysdbaSql*plus:release 11.2.0.4.0 Production on Tue Sep 30 10:28:30 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition release 1

There is a friend in a storage space for ASM use, there is insufficient space, and then use another storage LUN to the ASM Data Disk group to increase ASM disk, run for about 1 days after the ASM disk group directly dismount, Database crash. And

These two days modified the following database configuration file, the results of the following error message background, as follows (mainly concerned about the red part) Org.springframework.jdbc.support.MetaDataAccessException:Error while

Problem Description: When landing Oracle database, whether from SQL Plus or from Toad Landing, there will be no landing on the phenomenon. Prompt for package receive failed: ORA-12637 appears. Workaround: Modify the Sqlnet.ora file,

oracle|xml| Conversion In Oracle's 10g 2nd edition, Oracle introduced a full-featured, self-contained XQuery engine integrated with the database that can be used to complete various tasks related to developing XML-enabled applications. XQuery is a

Description of the phenomenon:It is normal to compile procedure with Plsql developer connection. Once the test starts to enter debug mode, it is stuck.The initial guess is that there is no permission, but the DBA role, if not the right will directly

Oracle 11gR2 RAC database cannot be connected (Ora-12537:tns:connection closed) Resolution[Email protected] ~]$ Sqlplus/nologSql*plus:release 11.2.0.1.0 Production on Wed 29 21:06:10 2012Copyright (c) 1982, Oracle. All rights reserved.Sql> Connect

Directory Db_name DBID Db_unique_name: Instance_name: Sid: Service_Name Global_database_name: Db_name① is a database name that cannot exceed 8 characters in length, and is recorded in DataFile, Redolog, and

Server and client on the same machine, can use BEQ connection, beq connection can be understood as the direct communication between processes, do not need to go network monitoring, higher performance.Reference mos:how to Connect Using the-bequeath

This week's book is the Ultimate guide to Oracle's C PL (SQL) programming, published by the mechanical industry press, Sun Fingdong, Wang Yu, Guo Xiaohui. Content Introduction: The ultimate guide to Oracle 12c PL/SQL is the most

Today, developed to send a message that a stored procedure would like to insert data through Dblink to the target library, but error ora-02069:global_names parameter must is set to TRUE for this operation, Want me to modify the Global_names

After retrieving the project error missing artifact com.oracle:ojdbc14:jar:10.2.0.4.0.Because of Oracle's OJDBC charges, there is no Ojdbc14-10.2.0.4.0.jar package when the MAVEN project is imported.Workaround:Configure the local library. To

Use Oracle's security External Password Store feature to implement a password-free login databaseAuthor: Zhao Full text network name: Guestart650) this.width=650; "Src="

Recently to the database to do patrol, always found warning:aiowait timed out 1 times error, the following alert content:Thread 1 cannot allocate new log, sequence 52198Private Strand Flush Not completeCurrent log# 5 seq# 52197 mem#

All of Oracle's garbled solutionsis not often see a variety of garbled, see the head on the big, we do not fear, all the problems will have one or more than one solution, there is a famous saying good: million law is not away from its trace. Online

Select Tools > Preferences > Options > Under plsql Developer: "Oracle Home" and "OCI Library"oracle10g in D:/oracle/oracle home for d:/oracle/product/10.1.0OCI Library for D:/oracle/product/10.1.0/db_1/bin/oci.dllRestart Plsql Developer after

The official documents are described as follows:3 Installing Oracle Grid Infrastructure and Oracle Real application ClustersCaution:After installation are complete, does not remove manually or run cron jobs that remove/tmp/.oracle or/var/tmp/.oracle

Source from: http://hwhuang.javaeye.com/blog/650903 KeywordsConcepts of nested transactions and autonomous transactionsUse of nested transactionsUse of autonomous transactions1. Concepts1. nested transaction ):It refers to one or more sub

Oracle SQL handler, yesDesigned for Oracle database developers and operatorsA carefully crafted Oracle client tool:Ultra-intelligent SQL Editor;Ultra-convenient table operations(You can update the data warehouse table by modifying the cell data of