Oracle

Prompt for "password expires after ora-28002:7 days" when logging into Oracle database using Sqlplus."Cause/Trigger factor"This is due to the fact that "password_life_time=180 days" is set in the default profile in oracle11g."Impact and

EBS system passwords are divided into four categories, and changing passwords requires compliance with regulations, specifications, and, in particular, backups. 1. operating system users, such as Root,ora,appl,grid. "Modify Method"use passwd this

Operating Environment: AIX + 11g + PLSQL Includes the following content: 1. SQL statement execution process 2. optimizer and execution plan 3. Properly apply Hints 4. Indexes and Application Instances 5. Other optimization technologies and

Sysdate [function]: returns the current date. [Parameter]: No parameter, no brackets [Return]: Date [Example] select sysdate hz from dual; return: Last_day (d1) [function]: return the date of the last day of the month where the date d1 is located. [

Oracle backup is divided into two types: Logical backup: expdp/impdp is only used to store the exported data. Therefore, only the data saved during Backup can be recovered, Logical backup is suitable for backing up tables with few

Today, I encountered a problem, which is easy to say, but it bothered me for half a day. After upgrading the database, a function can not run, in the background to observe its SQL, found that SQL contains a package can not be executed, error ora-009

  Import java. io. FileInputStream;Import java. io. FileOutputStream;Import java. io. IOException;Import java. io. InputStream;Import java. io. OutputStream;Import java. SQL. Connection;Import java. SQL. DriverManager;Import java. SQL.

This article will introduce you to some self-knowledge about tde in oracle. If you are interested in tde, please refer to this tutorial. Oracle's transparent data encryption is part of Oracle's Advanced Security Options and requires additional

A few days ago, Oracle Database not only acquired Sun, but the database giant also acquired Java. Larry Ellison, the chief character of Oracle, also considered JAVA as the most important technology in all Oracle acquisitions. But now the fate of

The following articles mainly introduce the example of Oracle Database DBA interview questions. This article describes the basic mode of Oracle Database DBA interview questions in a one-Answer manner, the following is an introduction to the related

Many new users may not know how to query all tables and data in oracle. The following describes how to query all tables in oracle for your reference. SELECT t. data_type FROM user_tab_columns t Group by t. data_type; -- Created on 2010-8-2

Mongoisedb, an open-source database vendor, declared war on Oracle, the database market leader, based on a survey ". The survey shows that Oracle is not good for open source. The survey sample is from 600 people at the JavaOne conference. Sampling

　Oracle DatabaseDespite being a powerful database systemHackerThat is to say, no matter what computer system, people can always find a way to attack it, Oracle is no exception. This article will discuss with you how hackers reach out to the data you

This article provides an indirectExcelData Import inOracleMethod: UseSQL ServerClose relationships with Excel. in SQL Server, use the OpenDataSource method to read Excel and spell the data into an oracle-compliant SQL statement. Run the following

Oracle 10g ClientThe installation configuration is very important for Oracle users. installing and configuring the Oracle client properly will bring great convenience to our work. This article describes how to install and configure the Oracle 10g

Oracle handbookSeriesVirtual Private Database VPDThe usage is what we will introduce in this article. VPD, Oracle Virtual Private Database, that is, Oracle Virtual Private Database, refers to the application of some policies, this allows users to

In Oracle 10 Gb, the Flash back family is divided into the following members:Flashback DatabaseFlashback DropFlashback TableFlashback Query (Flashback Query, Flashback Version Query, and Flashback Transaction Query)The following describes Flashback

In Oracle 10 Gb, the Flash back family is divided into the following members:Flashback DatabaseFlashback DropFlashback TableFlashback Query (Flashback Query, Flashback Version Query, and Flashback Transaction Query)The following describes Flashback

The company just launched a set of Oracle 11gR2 RAC. When MEMORY_TARGET memory is set to 12 GB, an error is reported during startup:ORA-00845: MEMORY_TARGET not supported on this system  00845,000 00, "MEMORY_TARGET not supported on this system"// *

Oracle 11g Release 1 (11.1) tablespace -- create and expand (permanent) tablespaces this article content create (permanent) tablespaces view tablespaces extended tablespaces www.2cto.com creation (permanent) tablespace Oracle manages tablespaces by