oracle data integrator 11g cookbook

Tags: style blog color using file data sp div problemThe backup file was exported from 11g with the exp command, and the above error occurred with IMP Import under 10g, in the case of a lower version of the backup that does not support a higher version, so the use of 11g test, or the above problem.In fact, the size of the table space is not enough, the following

The mofei theorem verifies everything that exists, so the Oracle 11g installed on RedHat is hit. I was careful when installing the machine and did not dare to restart the machine (because it was my first installation, so I was particularly worried). I was afraid of problems, so I did not close the machine after the installation was successful. Just a few days ago, the power was cut off due to

Oracle 11G Single Instance uses asm, and test the migration of data files to other disk groups 1. configure/etc/hosts network vi/etc/hosts192.168.1.181 asm asm.oracle.com 1. disable FIREWALL 2. disable SElinux vi/etc/selinux/config => SELINUX = disabled 2. create a user and group groupadd-g 5000 asmadmingroupadd-g 5001 asmdbagroupadd-g 5002 asmopergroupadd-g 6000

BKJIA quick translation] This article gives a brief overview of Data Pump enhancements in Oracle Database 11g R1, including the following: ◆ COMPRESSION) ◆ Encryption parameters A. ENCRYPTION and ENCRYPTION passwords ENCRYPTION and ENCRYPTION_PASSWORD) B. Encryption Algorithm ENCRYPTION_ALGORITHM) C. encryption mode ENCRYPTION_MODE) ◆ Transmit TRANSPORTABLE) ◆ Pa

=scott:tom View the results of the import, using the Tom user connection Export Table Space Create a table AA on the XX table space and insert a record for the table Export Table Space Delete data files while table space xx is deleted The AA table is gone. Import Table Space Before you import a tablespace, you need to create a table space of XX Import Table Space xx Verify that the AA table recovers back. Export Full Library [Email protected]]$

;ConfigurationName:c1Enabled:yesProtection mode:maxavailabilityDatabases:Dg-primary DatabaseProd1-physical Standby DatabaseFast-start failover:disabledCurrent status for "C1":Warning:ora-16610:command "EDIT DATABASE prod1 SET Property" in progressDgmgrl> Switchover to PROD1Performing switchover now, please wait ...New Primary Database "Prod1" is opening ...Operation requires shutdown of instance "DG" on Database "DG"Shutting down instance "DG" ...Ora-01109:database not openDatabase dismounted.OR

ORACLE 11G Data Guard role conversion, 11 gguard1. ORACLE login uard Role SwitchingDataGuard is now the mainstream disaster tolerance solution. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission mode and asynchronous delay transmission mode, it can even become a remote disast

conversion is complete, you can reset the standby run mode as needed. The operating mode of the conversion repository is because the standby is running in maximum protected mode and cannot be failover, and if the primary library is running in maximum protected mode and the standby is in communication, the SQL operation to change the standby to the best performance mode will not succeed. Because the failover operation moves the main library out of the Dataguard configuration, these features

New Features of Oracle 11g Flashback Data Archive instance, 11 gflashback Flashback Data Archive (flash back log archiving) is actually used to save undo Data for a long time. For some important tables, you can customize the retention period of their historical records, its

stops the SQL app to activate the main library. Without the finish apply clause, the current target repository does not apply redo logs that have not been applied until the target repository is transferred to the primary library role. 5. Recover other repositories after failoverEnsure that other existing repositories continue to provide protection for the new primary library.6. Back up the new main libraryAfter failover is executed, it is a necessary security measure to back up the new primary

Tags: ACL director style BSP exp ora PWD Benefits users[Email protected] ~]$ mkdir datadump[Email protected] ~]$ CD datadump/[Email protected] datadump]$ pwd/home/oracle/datadump sql> Create or replace directory DIR_DP as '/home/oracle/datadump '; Directory created. Sql> Grant Read,write on directory DIR_DP to Scott; Grant succeeded. Export a specified row in a table [[email protected] datadump]$ EXPDP scot

V$parameter Record values for all items in the initialization parameter file V$lock Set all information for an object lock by accessing a database session V$session There's a conversation message. V$sql Log details of SQL statements V$sqltext Record statement information for an SQL statement V$bgprocess Show background process information V$process Information abo

There is a new feature in 11G. When the table has no data, no segment is allocated to save space. Solution: 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 exported. 2. Set the deferred_segment_creation parameter. Show parameter deferred_segme