Solution to ORA-01417 under Oracle 11g
Today there is customer feedback, there is a SQL on 12C no problem, on Oracle 11g, the error is reported, the error content is ORA-01417: The table can be externally connected to at most one other table. This section analyzes the SQL statements and abstracts them into the followin
Oracle 11g Alert Log location Oracle 11g Alert Log location 1. Obtain ADR-related information by querying the v $ diag_info View
ADR(Automatic Diagnostic Repository)--> A a file-based hierarchical data store for managing diagnostic information, including network tracing and logging.
Code:
sys@ora11g>select * from v$dia
The following is a summary of the problems encountered when oracle 11g uses deferred_segment_creation to create a feature. Problem 1: You can create tables in all tablespaces. Problem 2: exp cannot export empty tables. Problem 1: Version: oracle 11.2.0.1.0
Select * from v $ version; create user aaa and grant the connect and resource roles to the User, but revoke
restriction can be used only when there is no record in the table or the default value is specified.1.3 DescriptionThrough the above description, I have a certain understanding of add column. Before Oracle 11g, if we want to add a column that is not empty, we need to specify the default value. If the table is very large, after adding the column, update all records in the table and add new default values. T
wasn't restored from a sufficiently old backupOra-01110:data file 1: '/OPT/ORACLE/ORADATA/TPY100/SYSTEM01.DBF 'Is the standby monitoring is not open, using lsnrctl start, start monitoring, and then open the database will not error.sql> ALTER DATABASE recover managed standby database using current logfile disconnect from session;The test has the following statement:Sql> select sequence#,applied from V$archived_log;Sql> select Process,status from V$man
Tags: ada parameter mode space min Ram Create base IAREnvironment: Simulating the creation of the main library use the Install option in the DBCA Start graphical interface option---> select Create and configure a databaseCreate a mock-up library using the Install option in the DBCA Startup graphical interface option---> Check the install database software onlyPreparation using the Oracle 11g Rman feature fo
When Oracle 11g is exported using EXP, empty tables cannot be exported, and 11 gexp
I. cause:There is a new feature in 11G. When the table has no data, no segment is allocated to save space.1. insert a row and then roll back to generate a segment.This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be export
Detailed introduction to services and services required for Oracle 11gAfter successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your c
Tags: Oracle 11g r2 Standard Edition 64-bit Linux installationInstallation Environment:Redhat ES 5.5 64-bit, system memory 8g,swap 10G, Oracle 11G R2 Standard EditionOne, Oracle pre-installation PreparationCheck the package and you must install it all:binutils-2.17.50.0.6com
Tags: Session set EPO BSP Ongl important tips title IDTJob required, installed Oracle 11g, an error occurred while importing the backup data on other machines:IMP-00019: Deny row due to ORACLE error 12899IMP-00003: Encountering ORACLE error 12899ORA-12899: Column "ZHENG". " D_dic "." Dicexplain "value is too large (act
Nothing's going on today. Installed Oracle database, but in this process encountered a lot of problems, here want to share with you.At first I installed the Oracle 12c, but this installation does not matter, Ann me a full half a day is not well, in the configuration of Security window there is no time, the current user does not have access to the temporary folder permissions, at that time, Baidu has a lot o
, change back to db_name = 'symp3 ', the same db_name should be set for the same DG -- The following is the configured backup database parameter file, which only lists the modified parts. If the original pfile file contains the same entries, you can comment on it or delete [Oracle @ linux3 ~]. $ Tail-20 $ ORACLE_HOME/dbs/initsybo5.oradb _ unique_name = sybo5log_archive_config = 'dg _ Config = (sybo3, sybo5) 'Log _ archive_dest_1 = 'location =/u01/data
In Oracle 11g RAC, it is found that both the Solaris and GSD services are in the offline status, which is the default situation of Oracle 11g RAC. Even so, the use of the database is not affected, because the resource for the WLM is used, WLM is available in 11.2.0.2. GSD is used to support interaction tools such as db
16384-n 16384
Fi
Fi
Iii. Install ORACLE software
[Root @ redhat ~] # Su-l oracle
[Oracle @ redhat ~] $ Cd database/
[Oracle @ redhat database] $./runInstaller
Select to install only the database software, and run as root during installation.
[Root @ redhat ~] #/Oracle/or
Before Oracle 11g, adding a column to a large table and setting the default value would be a tragedy. sometimes you have to select the online redefinition function to achieve this requirement. adding new columns and setting the default values in 11 GB only allows you to modify the data dictionary to achieve this function, greatly improving the efficiency.Add 10g columns (default)
SQL> select * from
1. DB_BLOCK_CHECKSUM parameter description
Before Oracle 10.2.0.3:
DB_BLOCK_CHECKSUM has two options: TRUE and FALSE. The default value is TRUE.
In Oracle 10.2.0.3:
DB_BLOCK_CHECKSUM has three options: OFF | TYPICAL | FULL. The default value is TYPICAL.
In Oracle 11g:
DB_BLOCK_CHECKSUM has five options: OFF | FALSE | T
Welcome to the Oracle community forum and interact with 2 million technical staff. On Monday, Oracle announced the beta version of OracleDatabase11g at its user conference. during a keynote speech at the OracleOpenWorld conference, ChuckRozwat, executive vice president of Oracle server technology, said that the beta OracleDatabase11g contains a solution package
Silent Installation of Oracle 11g R2 in CentOS 5.10
I found many articles about installing Oracle 11g R2 silently in Linux on the Internet, which are messy and varied! Come to the literacy class!
Install Oracle 11g R2 in CentOS 5.
Original: Oracle 11g for Windows Simplified Chinese installation processMy configurationOperating system: Windows Server 2003 SP2Memory: 1024M or more1. Download Oracle 11g AddressHttp://download.oracle.com/otn/nt/oracle11g/win32_11gR1_database_1013.zipBasic InstallationAfter decompression, it can be installed. Execute
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.