Database Administrator

1. Error description ORA-12801: error Signal issued in parallel query server P007 ORA-01722: Invalid Number 12801.00000-"error signaled in parallel query server % s" * Cause: A parallel query server reached an exception condition. * Action: Check

Last_ SQL _Error: Error 'unknown table 'bb' on query. Default database: 'test'. Query: 'drop TABLE 'bb'/* generated B The idea is to try to stop slave, reset slave, and add bb tables (define tables as needed). Remember the bin-log and position of

When upgrading the Oracle database from 11.2.0.1.0 to 11.2.0.2.8, the software upgrade is normal, the instance upgrade is normal, and the psu is upgraded. Run @? /Rdbms/admin/catbundle psu when applying, only part of the information is displayed,

Select SYSDATE from dual t; -- system dateSelect TO_CHAR (SYSDATE, 'yyyy/MM/DD HH24: MI: ss') from dual t; -- format the dateSelect TO_DATE ('2014 18:28:20 ', 'yyyy/MM/DD HH24: MI: ss') from dual t; -- format the dateSelect sysdate, sysdate-interval

1. Processing Run rcv11i_sa. SQL with reference to Note: 402245.1. Enter the po number, and the remaining values are default. Refer to Note: 1294177.1. If there is a problem with the above script, you can download the script from this Note to find

25. You need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employee2. Employee Name (character data type) that stores the employee name3. Hire date, which stores the date of joining the

24. Examine the structure proposed for the TRANSACTIONS table:Name Null TypeTRANS_ID not null number (6)CUST_NAME not null VARCHAR2 (20)CUST_STATUS not null VARCHAR2TRANS_DATE NOT NULL DATETRANS_VALIDITY INTERVAL DAY TO SECONDCUST_CREDIT_VALUE

I have created a new user named watson and granted the related priviledges as following: SQL> create user watson identified by watson; SQL> grant resource, connect, create session to watson;   There will be an error happened when we use this new

Query page: Statement 1 has more than 10 times better performance, but it is hard to understand because it has more than one top keyword !!!! 1. Primary Key r_object_id within 1 s Select top 100 * from (Select all doc. r_object_id "objid", doc. name,

Example of an external data experiment (4) Verify that external data finds out the non-synchronization caused by updata and delete operations. Extension: Example of the external data experiment (3) Verify that external data finds out the

Note: 1. The fixed-length character type occupies more space than the non-fixed-length character type, but the fixed-length character type does not need to be processed during field value setting, therefore, the processing speed is faster.

I can't help myself. My R & D colleagues directly shut down the plug-in power supply when testing the IBM 3650 server ??? The next day, after some restart, oracle opened the error ORA-00600: internal error code, arguments: [4194], [53], [41], [], []

5. Which SQL statements wocould display the value 1890.55 as $1,890.55? (Choose three .) A. SELECT TO_CHAR (1890.55, '$0G000D00') from dual; B. SELECT TO_CHAR (1890.55, '$9, 999v99') FROM DUAL; C. SELECT TO_CHAR (1890.55, '$99,999 d99') from dual; D.

In the charging system of the Self-reconstructed data center, you need to re-design the database. How can we design the database? This is also an important course "database principles" in our own test. For those who have passed this course, we must

1. Operating System CentOS release 6.2 (Final)   2. Create users and groups [Root @ mymaster1 ~] # Groupadd mysql [Root @ mymaster1 ~] # Useradd-r-g mysqlmysql   3. Unzip the installation package (decompress it to the location where you want to

Zookeeper Oracle 10g rac start/stop archiving Mode  If the Oracle database runs in archive mode, you may need to suspend the archiving of the database during database maintenance. After the maintenance is complete, restart archive mode.To switch

Recently, I have been following the master's foundation in the examination system. I am dealing with a large amount of data every day, including data import, data export, view import and export, and information check. I have gained a lot, I have

In order to reduce data redundancy during database design, it is generally designed according to the three paradigm. However, sometimes we need to obtain Fields are associated with several fields, but they are distributed in different tables. At

Exceptions encountered when accessing sybase using hibernate. Cocould not obtain connection metadata: ASE is now using a multi-byte character set, and the TEXT character counts have not been re-calculated using this character set for table 'spt _

2. View the Exhibit to examine the description for the SALES table. Which views can have all DML operations completed MED on it? (Choose all that apply .) A. CREATE VIEW v3AS SELECT * FROM SALES WHERE cust_id = 2034 WITH CHECK