Database Administrator

/** The core solution is to generate a column from 1 to 10 as the "secondary column "**/Select level l FROM dual connect by level [Problem]Two tables A BTable:Id pidA1 1A2 2A3 3Table B:Pid pnumber1 22 33 5Generate such information based on the

Oracle cursor type as input and output parameters: -- Cursor type input parameterDECLARE/* CURSOR cur_ttt ISSELECT 1 a FROM dual ;*/TYPE typ_cur is ref cursor;Val_cur typ_cur;PROCEDURE temp_sp1 (x_cur OUT typ_cur) ISBEGINOPEN x_cur for select 1 a

1. Create a test tableSQL> create table dump (id number, name varchar (20 ));Table created.SQL> insert into dump values (1000, 'tomsh ');1 row created.SQL> insert into dump values (1001, 'dumpceshi ');1 row created.SQL> commit;Commit complete.2.

1. Full database backupRMAN> run {Allocate channel c1 type disk maxpiecesize = 500 m;Backup current controlfile format '+ dgasm/backup/ctl _ % d _ % s ';Backup full database format' + dgasm/backup/db _ % d _ % s _ % p _ % T ';SQL 'alter system

Create persons:Create table 'persons '('Id _ P' int (11) not null AUTO_INCREMENT,'Lastname' varchar (10) default null,'Firstname' varchar (10) default null,'Address' varchar (50) default null,'City' varchar (10) default null,Primary key ('Id _ p '));

Cluster Health Monitor (CHM) is a tool provided by Oracle to automatically collect operating system resources (such as CPU, memory, SWAP, process, I/O, and network). CHM collects data once per second.These system resource data is very helpful for

1. References To do well, you must first sharpen your tools. Oracle official reference Document: Oracle Document. There are various documents, two of which are about oci and occi. C language: Oracle Call Interface Programmer's Guide and Oracle C ++

Oracle middleware is used to coordinate distributed databases. It has several notable features. 1. Unified API interface, transparent to the application, the application only sees one library 2. Server Load balancer dynamically detects database

HBase is a Hadoop database that provides random, real-time read/write access to big data. It is an open-source, distributed, multi-version, column-oriented, and storage model. I will first explain the overall structure of HBase, for example: HBase

Oracle build DB-LINK Test conditions Two servers Remote: IP: 192.168.0.18, SID: usertest, usertest, password: 123456 Local: IP: 192.168.8.90, SID: wjn, Username: userwjn, password: mosquito0 Parameter settings 1. view the database

How CSS works Before understanding the Brain Split processing process, it is necessary to introduce the working framework of Oracle RAC Css (Cluster Synchronization Services: Oracle rac css provides two background services: Group Management (GM)

You can export a data table from the local Oracle database with the file name. dmp, and then import the dmp file to the oracle table of another host. Deep feelings. I am not familiar with the functions of oracle files. First, modify the content of

1. query timeSQL> select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss') from dual; TO_CHAR (SYSDATE, 'yy-------------------2012-07-22 14:27:13 2. delete user SCOTT and objectsSQL> drop user scott cascade; 3. Set the system time format$ Export NLS_DATE_

Command for viewing logs:1. view log member informationSQL> select group #, member, status from v $ logfile order by group #;2. view the log group information and the currently used log GroupSQL> select * from v $ log;3. Add a log GroupSQL> alter

Today with PL/SQL 9 (the latest version) of the green Chinese cracked version, found in the execution of the query: select user_no account from lack_charge statement in the user_no error reported, the error is ORA-00911: invalid character (invalid

When MySQL replication is configured, the following error is reported when slave is started: Mysql> start slave;ERROR 1201 (HY000): cocould not initialize master info structure; more error messages can be found in the MySQL error logMysql> I

Slave_IO_State: Wait for the master to have an event Master_Host: current master server host Master_User: the current user used to connect to the master server Master_Port: current master server interface Connect_Retry: current value of the

Recently, when a product is installed and deployed for the first time, the background throws the following exception: Caused by: java. SQL. SQLException: Schema 'root' does not existAt org. apache. derby. impl. jdbc. SQLExceptionFactory.

Back up data from host A to host B Mysqldump-uroot-p vw> vw. SQL Back up the database file and restore it to the target machine B. The database version of B is 5.5.23, And the mysql version of machine A is 5.0.22. Mysql> source/root/vw. SQL; .....

A.1Full database backup. Command: Mysqlbackup-- Defaults-file =/home/mysql-server/mysql3/my. cnf -- user = root -- password = root -- databases = "mysql total2" -- with-timestamp -- backup-dir =/home/mysql-server/backup Parameter description: --