NAV: SLTechnology News&Howtos > Database >

• 

  Recovery Test after missing ORACLE Database Files

  1. The database version of the test environment is 11GR2. After making a full backup, shut down the computer, take a snapshot, and execute alter system switch logfile several times after each boot to generate archive logs. The subsequent tests are all based on such an end.

  2022-06-01 14:53:09 Views: 211
• 

  Trigger implements INSERT,DELETE,UPDATE between two tables

  Requirement description: the training record office enters the "training out" record, and after saving, synchronize the training contract to the "contract module" training record table PX_Record to create trigger step 1, create trigger: [insert_htandAL] step 2, when PeiXun_Reco

  2022-06-01 14:53:06 Views: 285
• 

  Linux install oracle

  Note: hostname must be consistent or there will be all kinds of errors: for example: [oracle@C1 j2ee] $emctl start dbconsoleThe following exception occu

  2022-06-01 14:53:06 Views: 211
• 

  The method of hanging up Oracle snooping and cleaning the full log of archived database

  Oracle data monitoring failed to restart method:-- listen to lsnrctl start-only take effect with a slight delay after startup. Lsnrctl statuslsnrctl stop-- forced kill monitor ps-ef | grep lsnrctlp

  2022-06-01 14:53:06 Views: 281
• 

  Reasons why oracle 11g exp default empty table does not export and its solution

  In oracle11g, when each table is initially created, no extents are assigned to this object by default. When data is inserted for the first time, the corresponding section is assigned. The corresponding control parameter is deferred_segment_creation=true if you want to keep up with the lower version.

  2022-06-01 14:53:05 Views: 227
• 

  Problems with startup of mysql binary installation

  Problems during startup after binary installation (mysql is installed under / application/msyql): [root@135 bin] # / etc/init.d/mysqld startStarting MySQL.1

  2022-06-01 14:53:05 Views: 281
• 

  OEM and common fault handling

  1. Oem:oracle Enterprise Manager, a graphical management tool for oracle with port number 1158, installed by default when accessing the installation database using https:// address: 1158/em, and can be rebuilt using the emca command. 2. There are two versions: dat

  2022-06-01 14:53:05 Views: 223
• 

  Oracle11G installation prompt INS-06101

  Install ORACLE11G on Redhat Enterprise6 and run $. / runInstaller prompt this is due to the inconsistency between the hostname and / etc/hosts file. First run $hostname my machine displays oracl

  2022-06-01 14:53:02 Views: 255
• 

  Query all implementations by default when the query parameter in SQL SERVER is empty (null)

  Method 1: when the publishing house screening condition is null, how to write SQL? 1 DECLARE @ publishers VARCHAR (50); 2 SELECT * FROM dbo.Book WHERE Publishe

  2022-06-01 14:53:01 Views: 231
• 

  Using python script to realize flushback with misoperation of mysql

  1. Introduction in oracle database, when a misoperation is submitted, we can use the flashback function provided by oracle to flashback the table to its pre-misoperation state. There is no native flushback function in mysql. When DBA is misoperated, the traditional recovery method is benefit.

  2022-06-01 14:53:01 Views: 206
• 

  Guidelines for using postgresql

  Centos series installation is divided into: yum installation source installation one, yum installation in accordance with the official installation documentation. Install Postgresql official yum repository yum install https://download.postgresql.

  2022-06-01 14:53:01 Views: 248
• 

  [DB written interview] in Oracle, how to stop the expdp data pump process completely?

  Real question 1. How to stop the expdp process completely? Answer: when using the expdp command, many colleagues accidentally press the CTRL+C key combination, and then enter the exit command (or network outage and other anomalies), resulting in the non-existence of the expdp process, but the Oracle database

  2022-06-01 14:53:00 Views: 279
• 

  Briefly describe what is a view

  1) it is a virtual table. 2) the content is similar to the real table and contains a series of column and row data with names. 3) the view does not exist in the database as stored data. 4) the data of rows and columns is used to customize the basic table referenced by the view, and is generated dynamically when the view is referenced.

  2022-06-01 14:53:00 Views: 272
• 

  Collection of basic statements of database ORACLE

  -- create a table FAMILYINFCREATE TABLE FAMILYINFO (FNO NUMBER CONSTRAINT FC001 PRIMARY KEY,-- constrains the field fno as the primary key

  2022-06-01 14:53:00 Views: 277
• 

  Shell script backing up MySQL database

  (1) ideas < 1 > install MySQL databases < 2 > create databases, tables, insert data < 3 > authorize a user name and password for backing up databases < 4 > commands for backing up databases: mysqldump-u root-p 1234-d MySQ

  2022-06-01 14:52:59 Views: 270
• 

  The ultimate solution of Oracle DISPLAY COLOR

  Checking monitor: must be configured to display at least 256 colors > Could not execute auto check

  2022-06-01 14:52:29 Views: 236
• 

  The difference between now and sysdate in mysql

  In mysql, now acquires the execution time of sql, while sysdate acquires the system time in the master-slave process of master and slave, which will lead to time inconsistency and error, such as Unsafe statement written t.

  2022-06-01 14:52:29 Views: 241
• 

  SQL optimization-millions of data query optimization

  Millions of data query optimization 1. Rational use of index index is an important data structure in the database, and its fundamental purpose is to improve query efficiency. Nowadays, most database products adopt the ISAM index structure first proposed by IBM. The use of the index should be appropriate, and the principles of its use are as follows: ● in

  2022-06-01 14:52:29 Views: 264
• 

  RedHat 6.5+11G+RAC+ASM installation and configuration (three nodes)

  1. Installation environment 1. Experimental environment virtual machine: VMware Workstation 8.0.3_64bitORACLE:Oracle Database11g11.2.0.3.0-64bit operating system: Red HatE

  2022-06-01 14:52:29 Views: 300
• 

  Create SQL users and delete SQL users

  -- create SQL users and associate databases-- create new SQL users, and associate windows users to connect to SQL database CREA

  2022-06-01 14:52:29 Views: 208