Oracle

What happens if I forget my Oracle user name password?Forgot the user name and password set at installation? Check the information on the Internet, finally solved!Method One:First enter the Sqlplus: There are two ways to enter, one is through the

Object permissions and System permissionsCreating a table and creating a session is a system privilege;The system administrator has access to the other tables.Log in with SysSqlplus Sys/on_change_install as SYSDBA;Create User WangwuCreate user

I. Differences in the types of BLOBs and CLOB in OracleBLOBs and Clob are large field types, blobs are stored as binary, and CLOB can store text directly. The two are interchangeable, or you can use LOB fields directly instead of the two. But in

There are several ways to generate SQL Trace: 1. Parameter setting: Very traditional method. System level: specified in the parameter file: Sql_trace=true or sql> alter system set sql_trace=true; Note: Sql_trace is enabled at the system level,

AIX under RAC Construction seriesAIX under RAC build oracle10g (v) Install Oracle, set up monitoringEnvironment Node Node 1 Node 2 Small machine Model IBM p-series 630 IBM p-series 630

ASM (Automatic Storage Management) is a new feature introduced in oracle10g R2 to simplify the management of Oracle databases, which is Oracle's own volume manager, which is used primarily to replace the LVM provided by the operating system. It not

Case statementCase SelectorWhen value1 and then action1;When value2 and then Action2;When Value3 and then Action3;.....ELSE Actionn;END case;Case expressionDECLARETemp VARCHAR2 (10);V_num number;BEGINV_num: = &i;Temp: = Case V_numWhen 0 Then ' Zero '

Recently, it has been a problem, that is, after the server power outage restart, the Oracle monitoring service does not automatically start (the monitoring service has been set to self-booting).Specifically, the monitoring service is set to boot,

OverviewMost of the business of the coping module is based on procurement and inventory operations, so the monthly closing of the Payables module should be closed after the purchase module and the Inventory module month.Monthly Knot StepAt the end

EXP-00091 error resolution when backing up Oracle on Unix/linux Error resolution when backing up data on Unix/linuxExp-00091:exporting questionable statistics. WorkaroundsToday's EXP data finds the following error:Exp-00091:exporting

Introduction to Oracle Database-level optimization analysis toolsWhen we optimize the diagnosis of the database, we need to collect the appropriate information for reference, from the personal experience, the statistical data are divided into two

I. EXP local export with IMP local importRun directly into the system command line.Exp command:1 exp username/[email protected] file=d:test.dmp full=y2 exp username/[email protected] file=d:test.dmp owner= (ly)3 exp username/[email protected]

ORA-01810 format code appears twice solution, ora-01810 Solution When you make a query page this morning, you need to query the spans of two time ranges. Use the TO_DATE function and write it at the beginningSQL codeTO_DATE ('2017-08-04 00:00:00 ', '

Example of mutual conversion between ORACLE milliseconds and dates, and oracle mutual conversion Convert millisecond to date SELECT TO_CHAR(1406538765000 / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH2

An example of random acquisition of any row of data (rownum) in the oracle database: oraclerownum Recently, when reading oracle data, I learned the concept of rownum. I used to only know how to add, delete, modify, and query database tables; After

[Translated from mos] When Oraclesoftware is installed, the/dev/null0 file is created.When Oracle software is installed, the/dev/null0 file is created.Reference Original:File/dev/null0 Is Created After Installation Of Oracle Software (Doc ID 1322550.

GoldenGate process abend, error: OGG-00868ORA-02396: ExceededMaximumIdleTime, PleaseConnectAgain GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again Reference Original:GoldenGate Processes Abend

Example of ORA-19527 and ORA-00312 error resolution in 10gDG In the past few days, we have set up a 10g DG Windows 2008 R2 testing environment, mainly to re-build a production database DG for a customer tomorrow. Some problems have been found, so I

Detailed example of Rownum paging in Oracle, oraclerownum In MySQL, we usually use limit to retrieve data sets by page. in Oracle databases, there is no convenient way to achieve paging like limit, therefore, we usually perform paging directly in

Lab environment: Source end: Ip: 192.168.40.10 DataBase: Oracle 11.2.0.1.0 ORCL OS: OEL5.6 OGG: fbo_ggs_Linux_x86_ora11g_32bit Target end: Ip: 192.168.40.128 DataBase: 10.2.0.1.0 ORCL OS: OEL5.6 OGG: fbo_ggs_Linux_x86_ora11g_32bit First, configure