Oracle

It's a strange question. Just learn to do Oracle when you do a test when the database startup prompts ORA-08103 error, the following cloud Habitat Small series to give you a moment. Database failed to start correctly due to ORA-08103 error in open

ExportIf you export, select the query results in the query results in Pl/sql SQL window and right click on the selection of COPY to Excel Import Method OneThe following article is mainly about how to use Sql*loader to export Excel-related data to

Oracle|sql server|access Database Tutorial All table names, field names SELECT * FROM user_tables WHERE table_name = ' username ' Use the following statement if you are logged on with this user:SELECT *From User_tables;If you are using another

Oracle Modified password expiration and ORACLE-02376 invalid or redundant resource exception resolution Oracle Modified password expiration As a result of the new features of oracle11g, it is common to encounter situations where the "password

 Srvctl is a tool for Oracle RAC Cluster configuration management. This article is a reference document detailing all the commands for Srvctl. 　　 SRVCTL ADD 　　 Add configuration information for a database or instance. In the Add instance, the

1, ORACLE12CR1 installation Environment configuration automatic configuration instructionsIn the ORACLE12C_R1 (e50529_01) official documentation, in the "Automatically configuring Oracle Linux with Oracle preinstallationrpm" section, the Linux 6

Recently on-line search how to install 64-bit Oracle in the case of win764, and use Plsql Developer to manage Oracle. So began to download the database on the Oracle website, download is a very simple thing, the problem is in Baidu when all said

Idea: You can remotely query the table of an Oracle database by adding a linked server to the SQL Server databaseEnvironment preparation, install the SQL Server database, install the Oracle driver, configure the Oracle connection in the configured

1. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle website, but you will need to apply for an Oracle account before you can download it.Current:

The first step in using the tool is to install the tool and configure the environment! The following is a brief introduction to the installation and simple utility of Oracle 11g Express.A. Download the installation processGo to Oracle's official

Netca/silent/responsefile/usr/local/soft/oracle/netca.rspThe error message appears as follows:[Email protected] oracle]$ NETCA/SILENT/RESPONSEFILE/USR/LOCAL/SOFT/ORACLE/NETCA.RSPParsing command line arguments:Parameter "Silent" = TrueParameter

DescriptionRaw: Unprocessed type, can store binary data or byte charactersLong: variable long string data, longest 2g,long has VARCHAR2 column attributes, can store long text in one table up to a long column "not recommended"Long RAW: variable Long

Temporary tables: Like normal tables, there is a structure, but the management of the data is not the same, the temporary table stores the transaction or the intermediate result set of the session, the data saved in the temporary table is only

1. The origin of the problemWhen the Oracle database field value is less than 1 decimals, processing with char type loses 0 of the preceding decimal pointFor example, 0.35 becomes. 352. WORKAROUND: Format the digital display with the TO_CHAR

 1. Oracle xdk Component Description   Before the description, we first use the following SQL statement to check the components in the database: SQL> Col comp_id for A15 SQL> Col version for A15 SQL> Col comp_name for A30 SQL> select comp_id,

Test environment: win2003 + oracle10gr2 Set environment variables:Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1Set java_home = % ORACLE_HOME % \ JDKSet Path = % java_home % \ bin; % PATH % Go to the ISQLPLUS directory:Cd % ORACLE_HOME % \

Oracle Performance Diagnosis art (milestone book on Oracle Database optimization) [Original book name] troubleshooting Oracle Performance[Original Publishing House] apress[Author] (Swiss) Christian antognini [same as the author's work]

In Oracle learning, architecture is the top priority. At the beginning, we can grasp its physical composition, file composition, and various file composition from a macro perspective. The deeper the knowledge, the better. Problems encountered in

Solaris software manages FTP and solaris software ftp Install Common Software Relationship between applications and system commands: The system command file is located under/bin/sbin or shell commands to complete basic management of the system.

Oracle 11gR2 Database and Active Data Guard migration case, 11gr2guard The customer's core system is composed of an Oracle Database 11.2.0.3.4 single machine and an Active Data Guard, which run on two PC servers respectively. The Oracle Linux 5.8 x86