Oracle

    Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local

  Set linesize 300; SET the Row Height Set pagesize 50; SET the number of entries displayed on each page Conn system/manager as sysdba; Log On AS SYSTEM Show user; displays the current USER SELECT * FROM tab; displays all tables of the current

When you use win7 to install oracle10g, it is likely that the related oraparam is displayed. if you are unable to install oracle10g due to an ini-related exception, follow these steps. 1. First, find and open the "\ oracle 10g \ stage \ prereq \ db \

· Physical Structure of the Oracle database:The storage structure of the Oracle database includes the physical storage structure and logical storage structure of data. The physical storage structure is the actual data storage unit, and the logical

I. IntroductionMaterialized View, as its name implies, is a physical view that is actually stored on the hard disk. query performance is better than normal views. Ii. materialized view principle:1. generate dataTwo major options: build immediate

I have prepared an article about using database cold backup to create physical standby. The cold backup of the database needs to be stopped, and it is not practical in the production environment, this section describes how to use rman for Hot

The SYS user logs in as a DBA under CMD: Run sqlplus/nolog in CMD. Then Conn/as sysdba // Create a temporary tablespace  Create temporary tablespace user_temp Tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf' Size 50 m Autoextend on Next 50

Start Oracle's help system-no longer afraid of forgetting commands. When you perform database management, you can't remember commands and syntaxes, especially for demonstration or on-site implementation, there is no way to check the manual. It is

Sqlplus hidden key combination SQLPlus at the SQL * Plus command line prompt on UNIX/Linux platforms, If you mistakenly press the key combination: Ctrl + S, the session will be locked, no command is displayed. Unlock the combination key: Ctrl + Q

Oracle function development 1. syntax for creating a FUNCTION: CREATE [or replace] FUNCTION name [(arg1 [mode] datatype [, ......])] -- When the parameter data type is specified, its length cannot be specified. Mode Value: IN, OUT, and in out. If

Oracle insert into syntax Basically, we have two ways to input data into the table. One is input at a time, and the other is input at a time. Let's take a look at the input method. Follow the Convention to introduce the syntax first. Syntax: Insert

This article briefly introduces the usage of oracle to_char () function. If you need to learn it, please refer to it. Oracle/plsql of the TO_CHAR function, which converts a number or date to a string. The syntax of the to_char function is:To_char

This article briefly introduces how to format SYS_GUID () in oracle to a standard format. If you need to learn more, you can see it. In Oracle, RAW (16) is used to save SYS_GUID () results, but the byte order is different from the standard GUID. As

This article introduced in detail about oracle ORA-3136, ORA-609 method, there is a need for friends can refer to this article Oh. Fatal NI connect error 12170. Version information:TNS for 64-bit Windows: Version 11.2.0.1.0-ProductionOracle Bequeath

This article analyzes the ORA-01031 error caused by SYS Local login or remote login, but also provides a ORA-01031 error solution, have encountered the same problem of friends can refer to the solution. if the database instance is installed on

The article according to your own encountered on the ORA-00205: error in identifying control file, check alert log for more info error Analysis in need of students can refer. Environment: oracle10gR2 solaris10Operation: If pfile is not created, the

This article introduces how to import and export elasticsearch. For more information, see. The Code is as follows: Copy code ORACLE_192.168.28.1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.28.1) (

This article will summarize the solutions to the problem that sys cannot log on remotely. If you encounter such problems, please refer to them in detail. SYSDBA cannot log on remotely (does this mean CRT remote logon) SYSDBA cannot log on remotely

This article will introduce in detail how to use the oracle trunc function. The trunc function is mainly used to operate on dates and numbers. The following is an example for your reference. Usage 1. TRUNC (for dates) date operation The date value

This article mainly introduces various methods and commands for starting and shutting down databases in oracle. The following is a good article for you, hoping to help you. Unix shutdown sequence: first shut down the database, then the operating