Database Administrator

1.Writing Purpose1 2.Create a Package in Oracle ERPDatabase using Toad or other pl/SQL tools. The source code is as follows:...1 (1) create a Package Header1 (2) create a Package Body.1 3.Procedure2 4.Use any User name/password to obtain the APPS

1,SYSTEMTablespace data file loss recovery Note: All the following experiments are based on the full-Database Backup above. 3.1DeleteSystemAll data files in the tablespace. [Oracle @ wwldb WWL] $ rm-rf RJE * [Oracle @ wwldb WWL] $ exit   3.2An error

In the previous post, I answered some questions from some netizens about how to wear a stored procedure that returns a set of records. I think many netizens already understand this. I will not talk about it more here. How to call a stored procedure

1. Requisitions Path: Purchasing> Requisitions There are only two types of requisitions. One is Internal Requisition, which is used for material application between Internal organizations; the other is Purchase Requisition, which is used to

SQL Server Cpu 100% is not very common. It generally causes performance problems, such as blocking, connections, and I/O disks. Therefore, the usage of SQL Server is generally low. However, in some cases, the Cpu usage is 100%. What operations does

SQL> conn hr /***SQL> select username, sid, serial #, module, action from v $ session; Select username, sid, serial #, module, action from v $ session ORA-00942: Table or view does not exist Solution: Sqlplus "sys/*** as sysdba"SQL> grant select on

Configure parameters according to the manual... [Oracle @ www.bkjia.com ~] $/Mnt/runInstaller-record-destinationFile/tmp/install_database.rspStarting Oracle Universal Installer... Checking installer requirements... Checking operating system version:

In Oracle 11g version, full-Table serial scan may use direct path read instead of db file scattered read used in earlier versions, obviously direct path read has more advantages:1. reduces the use of plug-ins and avoids possible use of plug-ins2.

1. the maximum number of lists IN the IN clause is 1000. If this number is exceeded, an error is returned. You can use a temporary table to solve this problem; 2. * The character length of the create trigger statement text cannot exceed 32 KB (the

MySQL database errors caused by power failure or abnormal shutdown are very common problems. There are two methods: one is to use the check table and repair table SQL statements of mysql, and the other is to use multiple myisamchk and isamchk Data

If the database contains a federated primary key, such as Vcode and Vcompany (view method, right-click the Oracle database table and then view the key information to find the UK Information) Verify whether the Vcode and Vcompany are associated

121. you want to create a new optimized database for your transactional production environment to be used by a financial application. while creating the database, you want the Oracle software to take care of all basic settings to optimize the

The error is as follows:SQL> conn system/test @ testERROR:A ORA-01034: Oracle not availableORA-27101: shared memory realm does not existLinux Error: 2: No such file or directory 1. Check the environment variables and check whether the monitoring

1. Create an Oracle global temporary table. The Code is as follows:SQL code DECLARECntInt; Begin -- If the temporary table exists, delete it. SELECT Count(1)IntoCntFromUser_tablesWhereTable_name ='Templogsmshall _ session'; If cnt> 0THEN

When I added a primary key to a Mysql table, I used the following SQL statement: Alter Table'Table name'Add Column'Column name'Int Not NullAuto_increment comment'Primary key'Before 'a column name '; The following two errors are returned: Error

Today, the Oracle SQL driver plug-in is compiled on Mac. The compilation process is recorded here for your reference. First introduce the compiling environment: Mac OS X 10.7.3, install Qt SDK 1.2 for Mac, XCode 4.2.1. 1. first, download the

Common index-related scanning methods are as follows:Index range scan ):1. for unique index, if the where condition is followed by ,... and... if the where condition is followed by =, then index unique scan may be executed.2. For none unique index,

We check whether the ASM disk space passes through the following routine: Export Oracle_SID = + ASM1 By checking the v $ asm_diskgoup view, you can check the usage of the disk space as follows:SQL> select group_number, name, total_mb, free_mb from v

Distributed Database computing involves distributed transactions, data distribution, and data convergence computing. Distributed Databases can achieve high security, high performance, high availability, and other features. Of course, they also bring

I.InstallOracle Linux 6.1System Here I use VBox for installation. For details, refer: Oracle Virtual Box installation instructions Install the following package during OS installation: Base System> Base Base System> Client management tools Base