Oracle

1. First, create a (new) User:Create user username identified by password;Username: User name for new usernamePassword: New user's passwordYou can also not create a new user, but still use the previous user, such as: Continue to use the Scott user2.

I. Connecting an Oracle Database Install the client: The Oracle database is built on the remote server, the local only needs to install a client, and then under the installation directory (D:\app\fangs\product\12.1.0\client_3\Network\Admin,

1. Copy standby control file from primary DB to standby DB and rename the file name and location in Stdby DB same as the P Rimary DB2. Copy password file from primary db to the standby db (keep both of them same)3. Use the Pfile to startup the

Change the Oracle archive path and archive mode   in oracle10g and 11g versions, the Oracle default log archive path is the Flashback recovery area ($ORACLE _base/flash_recovery_area). For this path, Oracle has a limitation, that is, the default is

1. Change the archive pathIn oracle10g, the default archive path is $oracle_base/flash_recovery_area. For this path,Oracle has a limitation that only 2G of space is available to the archive log by default, and you can use the following two SQL

first, set the Oracle database to archive mode1) Sql>shutdown normal/immediate;2) Sql>startup Mount;3) Sql>alter database archivelog;4) Sql>alter database open;5) archive log list;Note: Show parameter log_archive_dest see where the archive logs are

When you create a database, we may write many scripts that create a table structure. If many of these scripts are significantly inefficient to execute scripts one by one, how to execute scripts in bulk.First, put all the scripts into a

Method One:At present most of the database has the need of distributed query. The following is a simple introduction to configuring cross-Library access in Oracle.For example, there are 2 database servers and 2 databases are installed. Database

The XML structure is as follows: Frequency Division Division name = "2013_01freqband137_137p025m" display ratio = "0.530348" > Business Set > Business Primary= "1" owlcode= "Radioserviceextra2_m21" > footnote list > footnotes >5.55 footnotes >

Table operation Syntax DifferencesWhen building a table, only the self-increment syntax is different.The primary key (PRIMARY key), the foreign key (FOREIGN key), non-null (NOT NULL), unique (unique), and default (defaults) are the same, and the

1. The Oracle connection is slow during the test:conn = env->createconnection (user, passwd, connect_string);Stepping here, waiting for the return to be slow.Processing method:1, detection phenomenon problems:1) sqlplus [email protected] Database

Two days ago colleagues asked an oracle to use grouping to complete a statistical report function, this function is handsome. Developing a grouped report directly a SQL is done.Grouping (ColumnA) function means: If the current line is generated by

I. Overview of the partitioning table: Oracle's table partitioning capabilities bring great benefits to a wide variety of applications by improving manageability, performance, and availability. In general, partitioning can greatly improve the

Tkprof is a command-line tool provided by Oracle, the primary role is to convert the original trace file to a formatted text file, the simplest way to use the following:Tkprof LY_ORA_128636.TRC Ly_ora_128636.txtTkprof has many parameters, and in

Reprint Please specify source : http://blog.csdn.net/guoyjoe/article/details/386848191. Get the library cache Latch(1) The text of the SQL statement was not found in the handle of the parent cursor: SELECT * from Gyj_t1 where id=1;2. Release Library

Oracle 10g Oracle is designed for Grid computing, the G in 10g refers to the grid computing Oracle stores data in files, files that hold different information (data files, control files, log files) make up the physical structure of the database

Oh, spent one hours, around the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation efficiency. Oh.

About ORA-01031: insufficientprivileges troubleshooting Summary About ORA-01031: insufficient privileges troubleshooting Summary   A) File $ ORACLE_HOME/network/admin/sqlnet. oraDoes this involve oracle OS authentication or password file

Share: Oracle System Variable Function usage instructions, oracle VariablesIn Oracle databases, Oracle System variable functions are frequently used. Let's share the usage of Oracle System variable functions. Oracle functions are diverse. System

Differences between Oracle hard parsing and soft parsing: oracle and soft I. Summary Oracle hard parsing and soft parsing are common problems, so we need to consider when soft Parsing is generated, when hard Parsing is generated, and how to