Database Administrator

After installing Oracle, you want to use other Linux users to log on to sqlplus,$ Usermod-g oinstall zhou$ Cp/home/oracle/. bash_profile/home/zhou/. bash_profile Failed to find!The following problems occur:SQL * Plus: Release 9.2.0.1.0-Production

SQLJet is an independent pure Java implementation of the popular SQLite database management system and a software library that provides APIs. This API enables Java applications to read and modify SQLite databases. SQLJet does not support SQL queries,

Ubuntu has unixodbc. To connect to MSSQL or SYBASE, you need to install it first. To compile freetds, you need to install the packages unixodbc, unixodbc-bin, and unixodbc-dev. After installation, you can use tools such as ODBCConfig and DataManger.

1. ORA-12541: TNS: No listener Cause: the listener is not started or damaged. If it is the former, run the net start OracleOraHome81TNSListener command (the name may be different; If it is the latter, add a listener using "Listener Configuration" in

Create or replace view V_WTK_ALL Select a. id, o. short as FindDeptName, u. realname as FindUserName, f. name as FindWay, o1.short as ProblemAtDeptName, Z. name as szzz,. yhnr, s. name as SSZY, k. name as kind, w. name as whhg,. zgcs,. zgfzr,.

The SELECT statement of MySQL has the following parameter: SQL _CALC_FOUND_ROWS. This parameter can be used with the function FOUND_ROWS () provided by MySQL. When we use LIMIT ?,? During paging query, only the records you want are returned. For

1. After installing the Oracle database, You 'd better back up the entire Oracle folder before installing the application, because it is a "clean" database, similar to after installing the operating system, create a clean ghost. After the

Oracle instance Startup Process and file operations Initialize an instance Then mount the database Then load and open the database Initialize instance startup nomount First, oracle goes back to pfile and spfile to initialize the instance,

Oracle Online Segment shrinkage (Online Segment Shrink) refers to the fragments in the Online Segment space. It has the following features: Online, that is, in the segment compression process, DML is almost unaffected (DML will be blocked only a

To test a large amount of basic data, IMP imports data too slowly. You can use the following method to quickly back up and restore a tablespace in the current Oracle database; the following method is also suitable for data table space migration

./RunInstaller Graphic startup Error PRVF-0002: cocould not retrieve local nodename. The error message is as follows: [Root @ test68 OraInstall2013-09-06_04-43-39AM] # cat installActions2013-09-06_04-43-39AM.log The following lines report an

Note: The database should be supported in the archive mode. 1. Back up the SYSTEMG tablespace.[Oracle @ bys001 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Tue Sep 17 10:42:18 2013Copyright (c) 1982,200 9, Oracle and/or its

The vs debugging pg source code used in the pg kernel source code parsing class, VS is easy to use, but it is a little troublesome to configure the debugging environment. First, you have to install a windows system, preferably xp or win7, which is a

Because there are not many flash areas, select * from v $ flash_recovery_area_usage and find that the backup set occupies too much space.So delete obsolete; found the error ORA-19606: Cannot copy or restore to snapshot control file RMAN> delete

OS: CentOSDB: PostgreSQL9.3, OS user: postgres I. Compile the pg_dump backup script: # get the day of week 1-7 starting mon=1DOW=`date +"%u"`# define variablesDB_INSTALL_DIR='/opt/PostgreSQL/9.3'# DB_TYPE='PostgreSQL'# DB_SERVER='127.0.0.1'# DB_PORT=

1. Oracle 11g R2 installation manual (Graphic tutorial) For Windows Before installation, you must confirm the following points: There is no problem with your memory (this is very important, if your machine is often blue screen, then don't install it,

The default naming conventions for this file are:Init $ Oracle_SID.ora (in Unix environment)Init % ORACLE_SID %. ora (in Windows) By default, it is placed in the following directory$ ORACLE_HOME/dbs (Unix)% ORACLE_HOME %/DATABASE (Windows)This

MySQL 5.5 Command Line Client SQL common statements A. create databases and data tablesRoot Login MySQLCreate a database named demoCreate schema demo; USE the USE command to specify the demo DatabaseUSE demo; Create a t_message table with fields

I. Introduction PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. Some features are not even available in commercial

Redis. conf 1. Basic Configuration Memory Unit Representation #1 k = & gt; 1000 bytes# 1kb => 1024 bytes#1 m => 1000000 bytes#1 mb => 1024*1024 bytes#1g => 1000000000 bytes#1 gb => 1024*1024*1024 bytes The Unit is case insensitive 1 GB 1 Gb 1 GB Run