Results for NOT


61 to 120 of 22916 results. Prev  Next
Results per page:  20 | 40 |  60 


Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

3 Maintaining Data Integrity Through Constraints

When to Use NOT NULL Integrity ConstraintsBy default, all columns can contain s. Only define NOT NULL constraints for columns of a table … might be temporarily omitted. Some employees might not have a commission. Columns like these should not … have NOT NULL integrity constraints. However, an employee name might be required from the very … beginning,

Advanced Replication, 10g Release 1 (10.1)

A Troubleshooting Replication Problems

DDL Changes Not Propagated to Master Sitemaster definition site and the modification is not propagated to a master site, then first ensure that

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

7 C onfiguring Secure Sockets Layer Authentication

ORA-43001: PKCS11: token not foundCause: The smart card that was used to create the wallet is not present in the hardware security

Guide, 10g Release 1 (10.1)

24 Using Parallel Execution

When Not to Implement Parallel ExecutionParallel execution is not normally useful for: Environments in which the typical query or … execution is not useful in these environments because there is a cost associated with coordinating the … such resources are available, then parallel execution will not yield any benefits and indeed may be detrimental to performance.

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

7 C onfiguring Secure Sockets Layer Authentication

OID hostname or port number not setCause: Oracle Internet Directory (OID) connection information is not set. Note that this is not a

Oracle® Net Services Administrator's Guide, 10g Release 1 (10.1)

16 Troubleshooting Oracle Net Services

ORA-12154: TNS:could not resolve service nameCause: Oracle Net could not locate the net service name specified in the tnsnames.ora configuration … Configuration File Support" for configuration file location information Verify that there are not … contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain … name in your connect

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

2 Basic Components of Oracle Objects

FINAL and NOT FINAL Types and Methodspermit subtypes, the object type must be defined as not final. This is done by including the NOT FINAL … VARCHAR2(30), phone VARCHAR2(20)) NOT FINAL; / The preceding statement declares person_typ to be a not … as final and subtypes cannot be derived from it. You can change a final type to a not final

Oracle Database, 10g Release 1 (10.1)

Apache Tutorial: .htaccess files

When (not) to use .htaccess files, look at the documentation for that directive, and check the Context line for ".htaccess." When (not) to use.htaccess files

Replication Administrator's Guide, 10g Release 1 (10.1)

11 Troubleshooting Streams Replication

ORA-26687 Instantiation SCN Not SetTypically, this error occurs because the instantiation SCN is not set on an object for which an … do not want to use export/import, then you can run one or more of the following procedures in the … SET_GLOBAL_INSTANTIATION_SCN Some of the common reasons why an instantiation SCN is not set for an object at a … package or by running

Administrator's Guide, 10g Release 1 (10.1)

28 Administering the Scheduler

Why Does a Job Not Run?A job may fail to run for several reasons. First, you should check that the job is not running by … types of jobs that are not running: Failed Jobs Broken Jobs Disabled Jobs Completed Jobs Failed Jobs … of a broken job, the entire job is broken, and it will not be run until it has been fixed. For

Administrator's Guide, 10g Release 1 (10.1)

18 Managing Hash Clusters

Situations Where Hashing Is Not AdvantageousHashing is not advantageous in the following situations: Most queries on the table retrieve rows … clause of a query can be found with relatively few I/Os. The table is not static, but instead is

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

7 C onfiguring Secure Sockets Layer Authentication

ORA-43000: PKCS11: library not foundCause: The system cannot locate the PKCS #11 library at the location specified when the wallet was created. This happens only when the library is moved after the wallet is created. Action: Copy the PKCS #11 library back to its original location (where it was when the wallet was created).

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

1 Introduction

1.6.3 Why Not Code Using SQLLIB Calls and Not Use Pro*C/C++?SQLLIB is not externally documented, is unsupported, and might change from release to release. Also … SQL. SQLLIB is not an API. While it has user-callable functions, it is primarily a runtime library for

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

11 Migrating Table Columns from LONGs to LOBs

Some Implicit Conversions Are Not Supported for LOB Datatypesdatatypes to a LONG; however, implicit conversion from these datatypes to a LOB is not allowed. If your … ); -- Assuming that long_var is of type CLOB after conversion The following conversions are not

Oracle® Net Services Administrator's Guide, 10g Release 1 (10.1)

16 Troubleshooting Oracle Net Services

ORA-03121: no interface driver connection - function not performedCause: A SQL*Net version 1 prefix was erroneously used in the connect string. Action: Do not use

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

3 Maintaining Data Integrity Through Constraints

Choosing Between CHECK and NOT NULL Integrity ConstraintsAccording to the ANSI/ISO standard, a NOT NULL integrity constraint is an example of a CHECK … integrity constraint, where the condition is the following: CHECK (Column_name IS NOT NULL) Therefore, NOTNOT NULL constraint or a CHECK constraint. For ease of use, you should always choose to define NOT

Backup and Recovery Advanced User's Guide, 10g Release 1 (10.1)

15 Recovery Manager Troubleshooting

RMAN Does Not Recognize Character Set Name: ScenarioIn this scenario, you are connected to the target database while it is not open and attempting to … perform an RMAN operation. You receive the following error: PLS-00553: character set name is not … recognized RMAN Does Not Recognize Character Set Name: Diagnosis Typically, this message means that the … client, is different from

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

9 C onfiguring Multiple Authentication Methods and Disabling Oracle Advanced Security

Verifying that REMOTE_OS_AUTHENT Is Not Set to TRUETo verify that REMOVE_OS_AUTHENT is not set to TRUE, add the following parameter to the

Oracle Database, 10g Release 1 (10.1)

Apache HTTP Server Project

Content-Type change is not noticed after reload-alive's are being used. If either condition is not met then it works fine. See also Bug-ID's 4124329 and … advocate this though since bending over backwards for beta software is usually not a good idea … anymore. In theory. Content-Type change is not noticed after reload

Concepts and Administration, 10g Release 1 (10.1)

A Troubleshooting Data Guard

A.4.1 Switchover Fails Because Redo Data Was Not TransmittedIf the switchover does not complete successfully, you can query the SEQUENCE# column in the V … on the standby database. If the last redo data was not transmitted to the standby database, you can

Concepts and Administration, 10g Release 1 (10.1)

11 Managing an Apply Process

Specifying That Events That Satisfy a Rule Are Not Executednot execute events that satisfy a certain rule. Specifically, you set the execute parameter in this … process with the rule in its positive rule set does not execute an event that satisfies the rule … . For example, to specify that apply processes do not execute events that satisfy a rule named … positive rule set will not

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

3 Maintaining Data Integrity Through Constraints

Constraints On Views: for Performance, Not Data IntegrityThe constraints discussed throughout this chapter apply to tables, not views. Although you can … declare constraints on views, such constraints do not help maintain data integrity. Instead, they are

Security Guide, 10g Release 1 (10.1)

16 Developing Applications Using Data Encryption

Principle 2: Encryption Does Not Protect Against a Malicious DBAgaining DBA privilege, encryption will not protect against many of them. Examples include corrupting … should merely administer the database, but should not be able to see the data that the database … JR_DBA role might not include all system privileges, but only those appropriate to a junior DBA (such … intelligence agencies-----do

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

6 Coding Dynamic SQL Statements

Referencing Database Objects that Do Not Exist at Compilationmight know the tables definitions at compile time, but not the names of the tables. Dynamic SQL can

Guide, 10g Release 1 (10.1)

18 Query Rewrite

Rewrite Checks Dimensions Primary Key/Foreign Key/Not Null ConstraintsPrimary Key/Foreign Key/Not Null Constraints Matching SQL Text Not Required Not Required Filtering the … Data Not Required Not Required Join Back Required OR Required Rollup Using a Dimension Required Not … Required Aggregate Rollup Not Required Not

Application Developer's Guide, 10g Release 1 (10.1)

11 Migrating Applications from Earlier Releases

11.1.4 Procedures Do Not Need to Be Owned by CTXSYSPreviously, procedures used in user datastores, procedure filters, and user lexers had to be owned by CTXSYS. In Oracle Database 10 g, these procedures can be owned by any schema, so long as the index owner has execute privileges on them. This principally affects creation of preferences. In previous releases of Oracle Text, a user datastore created with: beginctx_ddl.create_preference('example','user_datastore');ctx_ddl.set_attribute('example','procedure','proc');end;

Developer's Guide, 10g Release 1 (10.1)

28 Importing and Exporting XMLType Tables

Resources and Foldering Do Not Fully Support IMPORT/EXPORTresources ) rather than table names, column names, and so on. This release however does not support this

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKC-1040 "Remote Shell is not known yet."}have rsh/ssh program installed on your system. PRKC-1041 "Remote Copy command is not known yet … not recognized " Cause: Cannot determine the location of your remote shell command (rcp/scp). Action … } requested by client is not recognized" Cause: Cannot determine the location of your remote copy … . PRKC-1048 "{0} is not

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

10 Detailed Recovery Steps

10.4.2 When Not to Use Data Guard SwitchoverSwitchover is not possible or practical under the following circumstances: Missing archived redo … logs Point-in-time recovery is required The production database is not open and cannot be opened Do … not use Data Guard switchover when local recovery solutions provide a faster and more efficient

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

1 Introduction

1.6.9 Why Does SPOOL Not Work in Pro*C/C++?SPOOL is a special command used in SQL*Plus. It is not an embedded SQL command. See "Key Concepts of Embedded SQL Programming ".

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKH-1013: "The oracle home {0} does not exist."Cause: The system was unable to find the oracle home supplied. Action: Check the full path of the oracle home and try again.

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

5 Advanced Design Considerations

Interfaces Not Supporting LOBs Greater Than 4 GigabytesYou can create and use LOB instances up to 4 gigabytes in size--"gigabyte LOBs"-- in the following programmatic environments: COBOL using the Pro*COBOL precompiler C/C++ using the Pro*C/C++ precompiler Visual Basic using OO4O (Oracle Objects for OLE)

Security Guide, 10g Release 1 (10.1)

16 Developing Applications Using Data Encryption

Principle 3: Encrypting Everything Does Not Make Data Securedoes not address access control issues well, and it is important that encryption not interfere with … data before it is stored may provide additional benefits. Since it is not being accessed on-line … , performance need not be a consideration. While an Oracle database server does not provide this

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

7 Oracle Configuration Best Practices

7.2.2 Do Not Set CLUSTER_INTERCONNECTS Unless Required for Scalabilitycluster interconnect and the default cluster interconnect does not meet the throughput requirements of

Concepts and Administration, 10g Release 1 (10.1)

14 Monitoring a Streams Environment

Listing the Database Objects That Are Not Compatible With StreamsA database object is not compatible with Streams if a capture process cannot capture changes to the … object. The query in this section displays the following information about objects that are not … compatible with Streams: The object owner The object name The reason why the object is not compatible … used by the capture processes

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKC-1002 "All the submitted commands did not execute successfully"Cause: This could happen either because some node in the cluster failed in the middle of a manageability operation or because the communication channel between nodes failed. Action: This could happen either because some node in the cluster failed in the middle of a manageability operation or because the communication channel between nodes failed.

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Oracle XML DB Provides Name-Level Not Folder-Level Lockingstatements will not be visible to other database users until the transaction is committed. Concurrent access … operations such as creating, renaming, moving, or deleting a sub-folder or file do not require that

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

10 Detailed Recovery Steps

10.3.2 When Not to Use Data Guard FailoverDo not use Data Guard failover when the problem can be fixed locally in a timely manner or when … database is not accessible or cannot be restarted. Data Guard failover should not be used where

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

11 Migrating Table Columns from LONGs to LOBs

LOB Columns Not Allowed in UPDATE OF Triggersin such triggers. For example, the following create trigger statement is not valid: create table t

Programmer's Guide, 10g Release 1 (10.1)

12 Direct Path Loading

Direct Path Loading a NOT FINAL Object TableA NOT FINAL object table supports inheritance and a FINAL object table cannot. Describing a NOT … FINAL Object Table Describing a NOT FINAL object table of a fixed derived type is very similar to … describing a FINAL object table. To describe a NOT FINAL object table of a fixed derived type: Note … into this NOT

Advanced Replication, 10g Release 1 (10.1)

A Troubleshooting Replication Problems

Replicated Objects Not Created at New Master SiteIf you add a new master site to a master group, and the appropriate objects are not created at the … Wizard to setup your sites, then you should not have any problems. You must have links both to the … administrative requests at all sites have completed successfully. If requests have not been executed

Concepts and Administration, 10g Release 1 (10.1)

A Troubleshooting Data Guard

A.1.1 Standby Archive Destination Is Not Defined ProperlyIf the STANDBY_ARCHIVE_DEST initialization parameter does not specify a valid directory name on the … standby database, the Oracle database will not be able to determine the directory in which to store

Application Developer's Guide, 10g Release 1 (10.1)

7 Performance Tuning

7.7.18 When is a CTXCAT index NOT suitable?Answer: There are differences in the time and space needed to create the index. CTXCAT indexes take a bit longer to create and use considerably more disk space than CONTEXT indexes. If you are tight on disk space, you should consider carefully whether CTXCAT indexes are appropriate for you. With respect to query operators, you can now use the richer CONTEXT grammar in CATSEARCH queries with query

Advanced Replication Management API Reference, 10g Release 1 (10.1)

7 Managing a Master Replication Environment

Option 2: The Old Master Definition Site Is Not Availabledefinition site is not available. Meet the following requirements to complete these actions: Executed As

Advanced Replication, 10g Release 1 (10.1)

A Troubleshooting Replication Problems

DML Changes Not Asynchronously Propagated to Other SitesIf you make an update to your data at a master site, and that change is not asynchronously … transaction has been pushed to the destination. If not, then you can also check to see how much … longer it will be before the scheduled link pushes the queue to the destination site. If you do not want … manually. If a scheduled link's

Oracle® SQL*Module for Ada Programmer's Guide, 10g Release 1 (10.1)

1 Introduction to SQL*Module

1.4 What SQL Statements are Not Supported by SQL*Module?and call the modules directly from an Ada host program. 1.4 What SQL Statements are Not Supported … by SQL*Module? DDL (Data Definition Language) is not supported. DML (Data Manipulation Language … ) statements other than SELECT, UPDATE, DELETE, and INSERT, are not supported. Transaction control … statements other than COMMIT

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

5 Managing Oracle Streams AQ

DML Not Supported on Queue Tables or Associated IOTsOracle Streams AQ does not support data manipulation language (DML) operations on queue tables or

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

G Using the User Migration Utility

Database not registered with the directory : : DB-NAME = < dbName >Database not registered with the directory:: DB-NAME = Cause: There is no entry for the database

Security Guide, 10g Release 1 (10.1)

16 Developing Applications Using Data Encryption

Principle 1: Encryption Does Not Solve Access Control Problemsencryption key to decrypt the data. Encryption would therefore not provide any additional security in … stored data is that it must not interfere with access control. For example, a user who has SELECT … privilege on EMP should not be limited by the encryption mechanism from seeing all the data he is

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on NOT NULL Constraints You cannot specify NULL or NOT NULL in a view constraint. You cannot…Unique Constraints A unique constraint designates a column as a unique key. A composite unique key designates a combination of columns as the unique key. When you define a unique constraint inline, you need only the UNIQUE keyword. When you define a unique constraint out of line, you must also specify one or more columns. You must define a composite unique key out of line. To satisfy a unique constraint,

Oracle® Net Services Administrator's Guide, 10g Release 1 (10.1)

16 Troubleshooting Oracle Net Services

ORA-12514: TNS:listener does not currently know of service requested in connectdescriptordatabase service) that has either not yet dynamically registered with the listener or has not been

Concepts and Administration, 10g Release 1 (10.1)

A Troubleshooting Data Guard

A.1.3 Standby Database Does Not Receive Redo Data from the Primary DatabaseIf the standby site is not receiving redo data, query the V$ARCHIVE_DEST view and check for error … the query does not help you, check the following list of possible issues. If any of the following … service name for the standby instance is not configured correctly in the tnsnames.ora file for the … not set to

Concepts and Administration, 10g Release 1 (10.1)

A Troubleshooting Data Guard

A.4.5 Switchover Fails Because Redo Data Is Not Applied After the SwitchoverThe archived redo log files are not applied to the standby database after the switchover. This … might happen because some environment or initialization parameters were not properly set after the … name at the primary site. Start the listener at the standby site if it has not been started. Check if … as follows:SQL> SELECT DEST_ID,

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKC-1022 "Could not get "node name" for node {0} in {1}"Cause: The clusterware cannot be contacted. This can occur because the clusterware was not

Oracle® Net Services Administrator's Guide, 10g Release 1 (10.1)

16 Troubleshooting Oracle Net Services

ORA-12521: TNS:listener could not resolve INSTANCE_NAME given in connect descriptorCause: The INSTANCE_NAME in the connect descriptor is incorrect, or the database instance is notnot running, start it so that it can register with the listener. You can use the Listener Control … : "Monitoring Services of a Listener" ORA-12525: TNS:listener has not received client's request in time allowed

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

6 System and Network Configuration

Storage Area Non-RAC Database RAC Database (CFS Available) RAC Database (CFS Not Available)RAC Database (CFS Available) RAC Database (CFS Not Available) Software area Regular file system

Performance Tuning Guide, 10g Release 1 (10.1)

17 Optimizer Hints

By default, hints do not propagate inside a complex view. For example, if you specify a hint in a query…Unless the hints are inside the base view, they might not be honored from a query against the view

Oracle Database, 10g Release 1 (10.1)

Authentication, Authorization, and Access Control

How to I make it not ask me for my password the next time?Because most browsers store your password information only for the current browser session, when you close your browser it forgets your username and password. So, when you visit the same web site again, you will need to re-enter your username and password. There is nothing that can be done about this on the server side. However, the most recent versions of the major browsers contain the ability to

Broker, 10g Release 1 (10.1)

9 T ro ubleshooting Data Guard

9.2.2 Log Files Are Being Accumulated on the Primary and Not Archived to Some Standby Databasesaccumulating on the primary database and are not being archived to some of the standby databases in … state of the primary database is ONLINE (not LOG-TRANSPORT-OFF ). Verify that the value of the … not available, you need to restart the standby database. If the error indicates no listener, you need

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKS-1001: ASM instance "{0}" does not exist on node "{1}"adding configuration for it. PRKS-1001: ASM instance "{0}" does not exist on node "{1}" Cause: The … operation. PRKS-1008: ASM instance "{0}" is not running on node "{1}". Cause: An attempt was made to stop … instances on the node. Action: Contact Oracle Support. PRKS-1026: ASM Configuration for node "{0}" does not … : Configuration





Was this page helpful?

Integrated Cloud Applications & Platform Services