Oracle

1. DIRECTORYSpecifies the directory where the dump and log files are locatedDIRECTORY = directory_objectDirectory_object is used to specify the DIRECTORY object name. Note that the DIRECTORY object is an object created using the create directory

Row_number () over (partition by col1 order by col2) indicates grouping by col1 and sorting by col2 within the group, the value calculated by this function indicates the sequential numbers after sorting in each group (the sequential and unique

The oracle wm_concat (column) function is frequently used. The following describes how to use the oracle wm_concat (column) function to merge fields. If you use the oracle wm_concat (column) function) if you are interested in function usage, take a

Solution:1. Run as administrator in win7 2. Modify the time zone Files required (the first half may vary depending on the path of your installation ):A: D: \ oracle \ product \ 10.2.0 \ db_1 \ WJLMGQS-PC_WJLMGQS \ sysman \ config \ emd.

During work, you need to import data from the GIS_WEICHAI_DATA_1S table in one database to the GIS_WEICHAI_DATA_1S table in another database. The database servers are all remote ! My implementation method is to use PL/SQL locally to operate two

When oracle ebs operates a FORM interface or a table in the background database, it is found that the table has been in the "suspended" status. It may be because the table is locked by a user, and other users cannot continue the operation.Copy

UPDATE1. Back up data first (security and performance improvement ).2. Batch update and batch commit to prevent lock tables.3. If the updated index automatically has a large volume of data, the index will be canceled first and then re-created.4.

 Automatic Workload RepositoryIt is an important component introduced by 10 Gb.Stores the detailed information and information about the database activity status in the recent period. The default value is7DaysThe predecessor of AWR is Statspack,

Sometimes it is unclear that all the values allowed for some parameters can be obtained by the following two methods:1. directly enter the error value and let the error promptCopy codeThe Code is as follows:SQL> alter system set "_

1. horizontal segmentation What is horizontal segmentation? In an image-like metaphor, there is only one window for dining in the canteen. The waiting queues are too long and all of them are in the S-type format. This makes it easy for the queuing

In layman's terms: The number of records connected by A left join B is the same as that of Table. The number of records connected by A right join B is the same as that of Table B. A left join B is equivalent to B right join   Table: Field_K, Field_A

This article describes how to replace NULL values in SQL Server, Oracle, and MySQL.In SQL Server Oracle MySQL What should I do if I find a NULL value in the database?1. MSSQL: ISNULL ()SyntaxJava codeCopy codeThe Code is as follows:ISNULL

During Oracle database manipulation, an error is prompted when logging on to the Oracle account, and the Oracle account is frequently locked. What are the causes of this fault? This article introduces this process and finds the cause of the fault

Today I encountered a strange problem:Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifierSQL> conn system @

Delete an Oracle database in a Linux operating system in detail:1. Disable oracle server and background processesPs-ef | grep oraTurn off the databaseShutdown immediate2. Disable the listener.Lsnrctl statusIf it is enabled, execute lsnrctl stop to

The following describes the hard-working processes in the background. System Monitor (SMON), Process Monitor (PMON), Database Writer (DBWn), Log Writer (LGWR) checkpoint Process (CKPT)1. SMON: Install and open the database. Install the database by

There are a lot of content about oracle optimization and the concept is complex, but you can summarize an outline as the direction to be considered, and then gradually refine it. The design, development, and adjustment of oracle optimization should

Add a user (a schema with the same name as the user is automatically generated as the user is created) Create user "TESTER" PROFILE "DEFAULT" identified by "TESTER" default tablespace "TESTDATA" temporary tablespace "TESTTEMP" account unlock;(To be

1 The syntax of the SQL statement is verified.SQL syntax check2 The data dictionary is searched to verify table and column definitions.Checklist name and field name from data dictionary3 The data dictionary is searched to verify security privileges

ORCLE database backup policy1. Use exp and imp commands to export and import databases.There are three modes:A. User Mode: export (import) all user objects and data in objects;B. Table mode: export (import) All or specified tables of the user;C.