Oracle

The following error occurred while entering exp in the DOS environment.. Exporting Pre-schema process objects and actions. Exporting external function library names for user Fjzyinfo. Export public type synonyms. Exporting private type synonyms.

How to modify the Oracle Default user password expiration time 1, look at the user's proifle, which is generally default: Sql>select username,profile from Dba_users; 2. View password expiration settings for the specified profile (such as

Download Oracle Database 11g with wget Daniel September 23, 2014 Leave a comment The project needs to deploy a new Oracle server, the room bandwidth is much faster than its own download, all to find ways to download the installation files directly

Navicat version: Navicat Premium 9.1.11 Oracle version: Oracle Database 10g Release 2 (10.2.0.1.0) The following figure, failed to connect to the Oracle database using Navicat Problem Reason:Navicat OCI.dll does not support the GBK character

Oracle Dataguard Build Manual First, preparatory work1, the installation of database software:Primary and Standby Install database software:Step 7: Select the recovery area for the database: Tick Specify the Quick Resume option and enable archiving.

In Oracle/plsql, the trim function removes all specified characters either from the beginning or the ending of a string. The syntax for the TRIM function is:Trim ([Leading|trailing|both[trim_character]] string1) Leading-remove trim_string from the

Some questions about the character set: Bloggers have recently begun to learn Oracle, have to say that Oracle's content is really too broad, learn it is not only the database itself, many times will involve a variety of operating systems, remember

How Oracle obtains system current time   Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual;    Oracle gets a time of year, quarter, month, week , the function of the day   select  to_char (sysdate, ' yyyy ')  from dual; --year     Select

Oracle stored procedure basic syntax stored procedures1 CREATE OR REPLACE PROCEDURE Stored procedure name2 is3 BEGIN4 NULL;5 end;Line 1:The Create OR REPLACE PROCEDURE is an SQL statement that notifies the Oracle database to create a stored

SYS and SYSTEM user differences 1 The most important difference, the importance of storing data is different SYS the base tables and views of all Oracle's data dictionaries are stored in the SYS user, which is critical to the operation of Oracle and

If you do not know the password for the System,sys user in Oracle, you can retrieve it as follows:First, the database is entered as a regular user:Execute the following command in Sql*plus:Sql>connect/as Sysdba (can also be connected in the

SELECT * from V$version; Select banner from Sys.v_$version;The results are as follows:BANNER1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-prod2 Pl/sql Release 10.2.0.1.0-production3 CORE 10.2.0.1.0 Production4 TNS for 32-bit

1. Oracle database Where Condition execution order: Because SQL optimization is more complex and is subject to environmental constraints, writing SQL must follow the following guidelines during development: 1.ORACLE parses the WHERE clause in a

First look at my own experimental environment is in what kind of archiving mode: Sql> Select T.log_mode from V$database t; Log_mode------------Noarchivelog Two. After determining that it is in the non-archive mode, I first create a regular table

Add_months: Add MonthSELECT Sysdate,add_month (sysdate,1) from DUAL;Sysdate add_months (sysdate,1)-----------   ---------------------03-1-8 16:2 03-2-8 16:21:59Plus Day:sql> SELECT sysdate,sysdate+1 from DUAL;Sysdate sysdate+1-----------   ----------

Oracle Imports data in a number of ways: it's about two very simple ways to do it (through existing tools). First, import. csv data through Pl/sql developer. Ordinary PC, this way generally can only import 20+w data, and then there is the risk of

First of all, rownum and rowid meaning: As the name implies RowNum is the line number/line number, and ROWID is the code/number/Unique identification number, so he is similar to the "Aaar8gaaeaaaaeraak" number, notice that he is not in order, that

--Scene: --In Oracle 11g environment --the error is as follows: Ora-06502:pl/sql: Numeric or value error: String buffer too small ORA-06512: in "Wmsys." Wm_concat_impl ", Line30--Check the reason: Wmsys. Wm_concat returns a varchar2, so the

To_date format (in time: 2007-11-02 13:45:25 for example) Year:YY two digits two-digit year display value: 07YYY three digits three-digit year display value: 007YYYY four digits four-digit year display value: 2007 Month:MM number two-bit month

--====================== Querying Oracle error logs and warning logsTo view the error log directory by commandSql> Show parameter background_dump_dest;Error log corresponding to the pid:3159 fuzzy query based on the error promptFind-name "*ORA*3159*.