Oracle

Today through EXP Migration Oracle data, because the password contains a lot of special characters, for a long time, did not succeed,After the hair on the internet to find ways.1 Exp UsageUnder Linux (password with a pair of double quotes, the whole

Other people visit me when prompted no listener, ping can ping through,TNS configuration is correct, according to the internet, I will be the Tnsnames.ora, Listener.ora in the localhost are changed to the local IP or the computer full name of the

An RMAN backup job fails, displaying the following error:Ora-19809:limit exceeded for recovery filesYour analysis shows this Flash Recovery area are full. which aCtions could-resolve the error and avoid this error in thE future? (Choose.)A. Take the

You is performing a block media recovery on the TOOLS01.DBF data fileIn the SALES database using RMAN. Which statements is correct in thisScenario? (Choose.)A. You must ensure that the SALES database is mounted or open.B. You must restore a backup

Oracle data type conversions: Show conversion Box implicit conversionsOracle Auto-Complete conversionAn explicit conversion is requiredl use double quotation marks to add characters to a date1Sql> SelectTo_char (Sysdate,'YYYY-MM-DD Day') fromdual;2

Description:JAVA springmvc+mybatis (Oracle and MySQL) HTML5 new tall still background framework bootstrap1. Support App phone app (Android and iOS) interface call2. New high-html5+css3.0+bootstrap development interface UI, beautiful and stylish,

Entry level, but the steps are meticulous, there is no theory, can be used as an introductory manual.1. New User ******************************** -----1.create OS User and group Groupadd ttadmingroupadd TimesTen mkdir/etc/

Anyone familiar with Oracle knows that by setting Oracle's nologging option, some operations can be done quickly, with the risk that a database backup might fail. There are a lot of things you can do with nologging, and gather the following

Oracle EBSGetting StartedOracle EBSFull name isOraclee-commerce Suite (e-business Suit), was in the originalApplication(ERP) is based on an extension that containsERP(Enterprise Resource Planning management),HR(Human resources management),CRMA

Each user in Oracle corresponds to a separate scheme (schema), with the same name as the user name, with many elements such as data objects, tables, views, triggers, stored procedures, and so on.The role of the management database in Oracle is

Some Oracle SQL required for reportingThe cold, stay at home and read the mastering Oracle SQL 2nd, found that Oracle is still very powerful, there are 200 light functions, those object-oriented query language is difficult to emulate, especially in

Organize the previous documents and put them on the blog to find them directly.Environment: Oracle Linux release 6.3 x86_84, Oracle 11gR2First, the host environment configuration1.1 GCC InstallationIn the ISO file packages can find the corresponding

In the database SQL optimization, the first is to optimize the existing database SQL, mainly including the following:1. What SQL is the database executing?2, has been executed SQL is?3. What is the most time-consuming first few SQL?4. What is the

In Oracle, indexes are basically divided into the following categories: B*tree index, reverse index, descending index, bitmap index, function index, intermedia full-text index, etc., most commonly B*tree index and bitmap index.(1) , index-related

Current system Environment Description:Win7x64+vs2012+iis7Current situation Description:Publishing the Web service, the following problem occurred while browsing: failed to load file or assembly "Oracle.web, version=2.112.1.0, Culture=neutral,

In Oracle, authorization is required to use the user after it is created.First, user management1. User and Role information query-- query All users SQLSelect * from dba_users; -- system permissions granted by the user or role select * from

Materialized views Overviewhttp://blog.csdn.net/tianlesoftware/article/details/4713553http://blog.csdn.net/hdhai9451/article/details/3875172Materialized view fast refresh related materialized view loghttps://docs.oracle.com/cd/B10501_01/server.920/a9

A tragedy caused by the dramatic increase in HugePagesORACLEsession not enabled Fault description: HugePages is not enabled in LINUX, the host memory is nearly 300 GB, And the SWAP is 32 GB. The SGA_MAX_SIZE setting of ORACLE is about 80% of the

Oracle-some SQL statements required for report Creation Oracle SQL for report It was freezing, and I stayed at home and read "Mastering Oracle SQL" 2nd. I found that Oracle is still very powerful, and there are two hundred optical functions. It is

PLSQL _ basic series 6_determine the operation NVL/NULLIF/COALESCE/NVL2, plsqlnvl BaoXinjian I. Summary The following functions are applicable to any data type and use null values:NVL (expr1, expr2)NVL2 (expr1, expr2, expr3)NULLIF (expr1,