Database Administrator

Oracle 9i provides powerful migration functions to migrate data from multiple databases to Oracle. The new Oracle migration tool provides a simple solution for migrating data from Access 2000 to Oracle 92010. This solution overcomes Chinese garbled

1. Download MongoDB, here the download version is: mongodb-linux-i686-1.8.1.tgz.tar. Http://fastdl.mongodb.org/linux/mongodb-linux-i686-1.8.1.tgz Related reading: Install and start MongoDB in Linux Advanced query example in MongoDB MongoDB Java API

I want to use MySQL in linux for my work needs today. After VM 7.1.3 is installed, the Red Hat Linux 2.6.18 is installed as needed ([Red Hat Enterprise. linux.5]. TLF-SOFT-RedHat.Enterprise.Linux.5.Update.2-XiSO.iso under the donkey), and from the

Oracle BBED (oracle block browser and editor tool)Installation and Use   BBEDTools can be used to change dataBlockBut not officially supported.   The installation process is as follows: $Cd $ ORACLE_HOME/rdbms/lib $Ls-al * bb *. o -Rw-r --1

MongoDB (from "humongous") is an open-source document-oriented NoSQL database developed using C ++. The storage format is BSON, and the mode is free, featuring high performance, easy deployment, and easy to use, it is very convenient to store data.

I have contributed a script to monitor the MYSQL process. I hope it will be helpful to you. Function: Monitors the MYSQL process and restarts upon failure. If the MYSQL process fails to be started, an Email notification is sent. The Code is as

Preface: When I used Oracle R12's consignment function, I encountered a very troublesome problem: price grabbing. Due to this problem, the consignment function is always unavailable in the company, and the inventory report basically requires them to

1. NLS Parameter Oracle called globalization support National Language Support (NLS ),You can set the NLS parameter at the Session, Instance, and Database levels.Session-level settings overwrite Instance-level settings, and Instance-level settings

1)Role of Wallet Starting from Oracle 10g R2, any user can log on to the database without a password by using Oracle Wallet (non-operating system authentication ), this is very useful for scripts that use user passwords to log on to the database for

In the work involving database operations, we often encounter equivalent comparisons rather than fuzzy queries for two strings: for example, compare two names to be equal? However, when entering a string into the system, the operator may enter

Accidentally forgot the Database Password, In this case, you only need to add Skip-grant-tables Then restart the service and log on to the database again. At this time, I successfully logged on to the data, but accidentally deleted all the users and

In Oracle 11g, the lock mechanism is further enhanced, mainly reflected in the following three aspects: Serializing Locks Locking Tables Explicitly Sharing Locks   Serializing Locks Some people also generalize this feature into DDL Wait

A friend said that the rebuild index reported a ORA-01652 error. And temporary tablespace is large enough. The rebuild index is 6 GB, and the remaining space of indextablespace is 2 GB. Ask a friend to increase the index tablespace by 10 Gb. The

Some people on the Internet have provided the best optimization ideas: 1. Extract the records that meet the conditions in the large table to generate a temporary table. 2. Associate the small temporary table with another small table. No matter

1. Description of Invisible Indexes Oracle can create invisible indexes starting from version 11g. The OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter is explicitly set to TRUE, unless invisible indexes are ignored. The default value of

1. Oracle 11g has a feature. If exp/imp is used to import and export the database, no data table cannot be exported, I have also encountered this problem. After research, I think it is best to use expdp/impdp to export and import data to avoid this

In addition to using files or SharedPreferences to store data, you can also choose to use the SQLite database to store data.On the Android platform, an embedded relational database-SQLite is integrated. SQLite3 supports NULL, INTEGER, REAL (floating

The following is a simulation process in Linux1. Simulate high CPU usage in a session, as shown below:DeclareNum int: = 0;BeginLoopNum: = num + 1;End loop;End;/ 2. Run the top command in the shell window to view CPU usage:Pid user pri ni size rss

If an error occurs when Renaming an Oracle table: you are not allowed to rename this table, try to drop the materialized view log on the table. SQL> create materialized view log on test_1; The materialized view log has been created. SQL> alter

My machine: AMD64x2 4400 + + 1 GB memoryPhase 1-compilation and installation:1. Download postgresql-9.1.3.tar.bz2 from sqlsql.2, copy the source code to the/usr/src/postgresql-9.1.3.tar.bz2 and cd/usr/src3, decompression: tar xjvf