Oracle

  When oracle 11g exports a database using exp, empty tables cannot be exported. Therefore, you must use a Data Pump to import and export the oracle database.   1. expdp   SQL> create directory name (for example, dmpbx) as storage address (for

  First look at our data: SQL> select count (1) from dave where cust_tel like '2013 ';   COUNT (1) ---------- 2723   In our Dave table, cust_tel had 0551 records starting with 2723. Now we have changed these records to 0556.   Let's test it using

  Oracle Net can be used for communication between databases: a user session of a database can execute SQL statements for another database. This can be done through the database link.     Create database link sync Connect to store identified

1. Custom composite variable query and output case:DeclareTYPE myrecord is record (Aa varchar2 (10 ),Bb varchar2 (10); -- defines compound VariablesRecord1 myrecord;BeginSelect a1, a2 into record1 from a where a2 = 'mmm'; -- assign a value to the

The udev facility dynamically creates device files in Red Hat 5. Manual changes to the permission, userAnd group IDs to a device file under/dev are lost after a reboot. To prevent this, create/Etc/udev/rules. d/99-oracle-permissions.rules file to

Today, when I use sqlplus to connect to Oracle on the server, I cannot connect to it. The database name on the server is cebdsp, and tnsnames. ora is configured Cebdsp =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.101) (PORT = 1521 ))(

Oracle 10g 10.2.0.1 RAC ORA-12520This error is very common. I have encountered it once on a single machine. The solution is to set local_listener. This time, I will try to see how it works. [Oracle @ R1 ~] $ Sqlplus system/test @ RAC SQL * Plus:

The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see:Http://andylhz2009.blog.51cto.com/728703/771481 C: \ oracle \

I wrote a blog post last week about partition tables: http://www.bkjia.com/database/201202/119377.html.However, I found that I did not write much. When your query conditions are not closely related to partition columns, partition tables will not

Linux Kernel Parameter size and Oracle has a large shutdown, such as ORA-27102 error, is caused by improper Kernel Parameter size. For details, refer to Blog:Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No

This is because the listener on the server is not started. In addition, check whether the IP address or port of the client is correct.Start listener: cmd: lsnrctl startDisable monitor: lsnrctl stopMonitor status: lsnrctl statusIf the above Code

The simplest scheduled Oracle task1. Create a table in PLSQL:Create table HWQY. TEST(CARNO VARCHAR2 (30 ),CARINFOID NUMBER) 2. Create a stored procedure in PLSQL:Create or replace PRocedure pro_testASCarinfo_id number;BEGINSelect s_CarInfoID.nextval

-- Query Information about all oracle tables, tablespaces, and database connections -- 1. select table_name, num_rows, avg_row_len, num_rows * avg_row_len --, 'delete from' | table_name | ';' from user_tables t order by num_rows * avg_row_len desc; -

Export: SQL> create directory dump_dir as 'e: \ ORA11GBAK 'SQL> grant read, write on directory dump_dir to icdmain; next, we will export data: expdp icdmain/icd directory = dump_dir dumpfile = icdmain090522.dmp job_name = ICDMAIN_EXPORT PARALLEL

INSTR (source string, target string, start position, matching serial number) in Oracle/PLSQL, The instr function returns the position of the string to be truncated in the source string. It is retrieved only once, that is, from the start of the

[SQL] simple use of triggers 1. Introduction to triggers database Triggers are a PL/SQL program associated with tables. When a specific data operation statement (Insert, update, delete) is issued on a specified table, Oracle automatically executes

L database Triggers are stored PL/SQL programs associated with tables. When a specific data operation statement (Insert, update, delete) is issued on a specified table, Oracle automatically executes the sequence of statements defined in the trigger.

I recently came into contact with Oracle Form Builder and encountered some problems in the application. The following is a summary of these problems:I. the installation of FormBuilder 10g FormBuilder 10g is incompatible with win7, so it cannot be

Oracle 11g asm basic operations View: v $ asm_diskgroupv $ asm_diskv $ asm_operation ---- ADD, delete disk alter diskgroup diskgroup_name {ADD ...} {DROP ...} [REBALANCE [POWER integer] [WAIT | NOWAIT]; eg :( avoid multiple rebalance operations)

The following example shows how to use rowid to obtain information about data blocks (objects, files, and data blocks). The following example shows how to use rowid to obtain information about data blocks (objects, files, and data blocks) row: the