Database Administrator

Sqlldr loads data into the database. The data in the External table is based on the operating system file, and the real data is not saved to the database, which is in the operating system file. Therefore, the data in the External table can only be

Use ctrl + c to exit the current status output mode. Run the following command: expdp userid/password attach = job_name to connect to the currently running import/export task. You can use job_name to specify the task name.1. add_file = test _ % U.

The remote database user test has a t table. SQL> showUser USERIs"TEST" SQL>Select*FromTab; TNAME TABTYPE CLUSTERID ----------------------------------------------- TTABLE SQL>! Cat/etc/hosts # DoNotRemove the following line,OrVarious

1. After logging on to Oracle, enter the following command: [Oracle @ localhost ~] $ Vi. bash_profile 2. Add from # huzia. #. Bash_profile # Get the aliases and functions If [-f ~ /. Bashrc]; then .~ /. Bashrc Fi # User specific

Question: As an Oracle DBA, it is inevitable to perform some operations on the tablespace in the database. This is an operation that I often perform when managing the database. It is recorded here, they are all presented in the form of examples. One

To execute the exp or imp command, first: 1. Check whether exp.exe and imp.exe files exist in the bin directory of the Oracle installation directory. Otherwise, the command may fail to be executed. 2. Alternatively, you can directly enterIn the bin

Oracle always makes decisions based on a certain time point of the query (the query is consistent from this time point ). That is to say, Oracle will ensure that the opened result set must be the current result set at one of the following two points

System and object permissions for Oracle databases: Alter any cluster: modify the permissions of any cluster Alter any index Alter any role Modify permissions of any role Alter any sequence Alter any snapshot Alter any table Alter any trigger Alter

Assume that there are three log groups, each of which has one member and the size of each member is 1 MB. Now we want to change the size of all three log groups to 10 MB.1. create two new log groupsAlter database add logfile group 4 ('d: \ Oracle \

My database (asm storage) is upgraded from 11.1 to 11.2. This function must be upgraded to 11.2 only when the delay section is created today. Check whether my instance's compatible is 11.1.0.0.0. Naturally, I think of alter systerm set compatible =

Database ora-27100: solution to shared memory realm already exists errors Environment:Operating System Platform Windows Service 2003 R2 x86Database Version: Oracle Enterprise 9.2.0.1 for windows x86 Today a customer database cannot start,

In pl/SQL tools, you need to change the value of a field in a line: Method 1. Repeat the table to edit the data. In this way, you can see the data you want to change at a glance when the data volume is small. However, when the data volume is

PL/SQL Developer: Version 8.0.3.1510Oracle: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0When we use PL/SQL Developer to connect to 11 GB, we find that PL/SQL Developer is slow in response.There are the following phenomena: 1. When

RAC-2 Configuration [Oracle @ RAC-2. ssh] $ ssh-keygen-t rsa Generating public/private rsa key pair. Enter file in which to save the key (/home/oracle/. ssh/id_rsa ): Enter passphrase (empty for no passphrase ): Enter same passphrase again: Your

1. Connect to the database: Cx = sqlite3.connect ('database. db'). cx is a database connection object and has the following operations: Commit () -- transaction commit Rollback () -- transaction rollback Close () -- close a database

A recently written data collection program generates a file containing more than million rows of data. The data consists of four fields, and the second field must be deleted as required, no suitable tool was found in linux. stream processing tools

Many of my friends have made mysql master and slave databases for a while, but sometimes they have taken a lot of detours and wasted a lot of time. The main problem is that there is no information about other ChaYue host configurations, I only read

A script is used to manually create a database for expansion. when running the stored procedure provided by R & D, the following error is thrown:ORA-29538: Java not installed The entire process is recorded below:SQL> select * from v $

I deleted the database by mistake. The boss was very upset. I had to recover the database within 30 minutes. In a hurry, I wrote a stored procedure, which is suitable for deleting the table on the day of recovery without remembering the table

Oracle's Optimal Flexible Architecture (OFA) refers to the naming conventions and storage location rules for Oracle software and database files and folders. It can be used as a group of good habits, so that users can easily find the file structure