Recently saw a lot of people talk about TNS or database can not log in and so on, simply summed up the following dongdong.
First of all, Oracle's network structure, to complex to say can add encryption, LDAP and so on. There is no discussion here,
First,cannot load OCI dll,126
Workaround: Tool-> option->OCI Select Oci.dll in bin in the Oracle installation directory, install Oracle 11g R2 under Win7, and when connecting to Oracle with NAVICAT, prompts the following error: Cannot load OCI DLL,
About star schema In the construction of the Data Warehouse, the star pattern shown in the following illustration is almost the most commonly used. It is called star mode because the E-R graphic in the pattern is like a star (it feels strange
July 8, 2013, Oracle China announced that the company's new generation of database oracle12c officially listed, and can be downloaded through the Oracle Technology Network (OTN). The product was released by CEO Larry Ellison at Oracle's global
Oracle TRANSACTION Isolation mechanism
Transaction ISOLATION Level: the degree to which a transaction's modifications to the database are isolated from another transaction that is parallel to it.
With two concurrent transactions accessing the same
1 Oracle Middle-Week related knowledge description
1.1 Date Format function
to_char (x [, Format]): Converts X to a string as format. X is a date, format is a formatted string that sets the format for which X is converted, and the format is W,WW,IW,
One, the description database version 11g, single instance ADG. The operating system version is SuSE SP3. ip:192.168.1.11 Repository ip:192.168.1.12 Second, the requirements of the main library needs to modify the IP address, to ensure the normal
I. Common operation of Oracle database create a constraint when creating a table1. Add constraints when creating a table----constraints are rules that define what data in a table should follow or conditions that meet----constraints are built on
What is predicate out of bounds? predicate out-of-bounds is the fact that the query condition of the SQL statement exceeds the scope recorded by the database statistics. predicate out-of-bounds causes the Oracle optimizer to incorrectly select the
real question 1,how to stop completelyEXPDPprocess? answer: Many colleagues are using EXPDP command, accidentally pressed ctrl+c key combinations, Then enter exit EXPDP 1 , check EXPDP whether the process is stillPs-ef | grep
The Oracle 18c was released in 2018-02-16 or with Oracle's cloud first concept, and 18c is now available on cloud and engineered Systems. Oracle 18c claims to be an autonomous database that reduces the work of many DBAs, and does a lot of DBA work
I. Description1, IFS (index full scan) single-block read, Iffs (index fast full scan) multi-block read.2, at the same time in a table in a full scan of a column, the speed of more than a block of reading is significantly faster than a single block
One. To see if the Oracle database is in archive mode:SQL code1.select Name,log_mode from V$database;NAME Log_mode------------------ ------------------------QUERY Noarchivelog2. Using the archive LOG LIST commandDatabase log mode No Archive
---restore content starts---1. Download 11g on the Oracle website firstOracle Database 11g 2nd edition (11.2.0.1.0) Standard Edition, Standard Edition 1, and Enterprise Edition, Oracle Database 11g 2nd edition for Microsoft Windows (x64) (11.2.0.1.0
first, the common view descriptionOracle SQL statement resource consumption monitoring, the most commonly used system views are:V$sqlV$sqlareaV$sqltextV$sessionV$sql and V$sqlarea are basically the same, documenting the SQL statistics in the shared
Install/configure Oracle Express
Oracle XE installer for Linux (I-don ' t care if you ' re running Linux or isn't, this guy is going in a VM): Http://www.oracle. Com/technetwork/database/database-technologies/express-edition/downloads/index.
Many applications require a unique number to be used as the primary key value, so you can build code in your application to handle this requirement, or you can use a sequence to produce a unique number. If you want to improve the performance of some
Oracle triggers. When a table is updated or inserted, data is synchronized to a table in another database. oracle Data is synchronized.
Two tables are the T_SRC_WEATHER_TSPG fields under User,
User B's t_src_weather table,
It is required that when
How can I recover the accidental deletion of Oracle Database Data ?, Delete oracle by mistake
When studying the database, we only consider how to use database command statements with a learning attitude. We did not think about how to use database
Create a tablespace user in Oracle (Code tutorial) and create a tablespace in oracleI. tablespace
Temporary tablespace
Example of creating a temporary tablespace
Create temporary tablespace duke_temp/* TEMPORARY tablespace name: duke_temp */tempfile
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service