Database Administrator

RMAN> report obsolete Direct delete will report this error:RMAN> delete obsolete;The RMAN retention policy is applied to this command.Set the RMAN retention policy to redundancy 1.Allocated channel: ORA_DISK_1Channel ORA_DISK_1: sid = 136 devtype =

Problem description: Oracle installed in Linux by a colleague, the default character set is not modified. WE8ISO8859P1 is used and Chinese characters are not supported, The problem is that the Chinese data entered by the client can be displayed.

Snap is used to extract one or more tables from a database to the local database. The operations are as follows: -- Glossary: Source-database to be synchronized -- Purpose -- database to be synchronized /* 1. Create a dblink :*/ -- 1. Create dblink

// Has the following binary tree and converts it into a table structure: Parent_id child_id weight ------------------- A B 2 B c 3 C d 4 B e 7 C f 2 // Calculate the product of the edge weight between the leaf node and the root node: Leaf

Read the Blob field of WMF and generate the wmf file./// /// Read the WMF field and generate a temporary WMF File /// Private void ReadWMFBlobField () { OracleConnection _ connection = new OracleConnection (m_connectionString ); Try { _ Connection.

Oracle11g data recovery prompt cannot insert NULL First, go to oracle enterprise management to delete user and recreate Command: imp user/password @ servername ignore = y full = y file = bak. dmp log = bak. log After the operation is complete,

When installing Oracle 11g R2, the following message is displayed: swap size failed. The SIZE of SWAP space is smaller than the SIZE of SWAP space required by ORACLE. You do not want to re-partition the SWAP partition. Therefore, create a SWAP file

/* Create Table */Create table A_ybl ( Y INTEGER not null, B VARCHAR (30) not null, L VARCHAR (20) not null );/* Create A backup table for table */ Create table A_ybl2 ( Y INTEGER not null, B VARCHAR (30) not null, L VARCHAR (20) not null );Create

Recently, we encountered a problem: when migrating data, we need to analyze the structure of other tables. At that time, the tablespace, table structure, and data of other databases were exported. After you return, you need to create these

Prepare to export the database from the server to the Local Machine for testing, 1. Install Oracle 10g on the local machine 2. Create a tablespace and a temporary tablespace 3. Create a user and be granted Permissions First, start SQL * puls

I learned about Oracle Table Partitioning and object-relational database system. 1. oracle partitioning Oracle partitions are introduced in oracle 8.0. This process physically breaks down a table or index into smaller and more manageable parts. In

1. 1. Create a New Oracle instance; 1, 2. copy and rename the previously installed ArcSDE 9.2 \ ArcSDE \ ora9iexe folder to ora9iexe2 (Path: ArcSDE 9.2 \ ArcSDE \ ora9iexe2). Just set dbinit. ORACLE_SID in sde maps it to the name of the newly

We usually need to configure the core parameters of the Linux system when installing and setting the Oracle database on Linux or replacing or upgrading the hardware, and then adjust the parameters of the Oracle system. Kernel. shmall is the physical

Special characters in Oracle & 1. SQL SERVER supports insertion. Update ezoffice. menuset Set righturl = '/defaultroot/InfoAction. do? Type = all & channelType = 0 & userChannelName = Information Management & userDefine = 0 & orderBy = date'

Environment: RedHat Enterprise 4 and enterprise 5 have passed the test (if Enterprise 5 is used, modify the system parameters) 10201_database_linux32 Part 1 configure the system environment before installation Configure Linux for OracleCreate a

Mysql does not allow remote connection by default, because it poses a great security risk. You need to manually add users who can remotely access the database. Method 1. log on to mysql locally, change the "host" item in the "user" table in the

I. Solve the problem: Solve the problem that the tablespace is large and the total display space is insufficient.The ORA-01536: space quota exceeded for table space 'aaa'Ii. Three solutions:(1) alter user USERNAME quota 100 M on TABLESPACENAME;(2)

1. DUMP DatafileBlock example There are three types of SCN in a data block of Oracle: The Block header SCN, the CSC (cleanout SCN) and the commit SCN recorded in ITL. If we want to view the content of a block or some blocks, we can dump these blocks

Read Blob data through JDBC to demonstrate code ImportJava. io. File; ImportJava. io. FileOutputStream; ImportJava. io. IOException; ImportJava. io. InputStream; ImportJava. io. OutputStream; ImportJava. SQL. Connection; ImportJava. SQL.

After MySQL enables bin-log, when calling stored procedures, functions, and triggers, the error 1418 is displayed: ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is