You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for REPLACE


1 to 20 of 1043 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

REPLACERPAD RTRIM

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 102 of 177

REPLACESyntax replace::= Text description of replace Purpose REPLACE returns char with every occurrence of … function. TRANSLATE provides single-character, one-to-one substitution. REPLACE lets you substitute one … example replaces occurrences of "J" with "BL": SELECT REPLACE('JACK and JUE','J','BL') "Changes"

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 43 of 59

REPLACE SCRIPTSyntax Text description of the illustration replaceScript.gif See Also: The syntax diagrams for "RUN" to determine which commands are included in the backupCommands, restoreCommands, maintenanceCommands, and miscellaneousCommands clauses

Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Migrating Temporary Tables to Oracle

Replace Temporary TablesYou should replace temporary tables to give the best performance in Oracle. You should always try … to replace temporary tables with standard Oracle SQL. To do this, you must first determine the

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0514 Misplaced REPLACE keywordCause: The REPLACE keyword was in the wrong position in the COPY command. Action: Check the syntax of the COPY command for the correct options.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0605 File file_name already exists. Use another name or STORE [SET] filename [. ext ] REPLACECause: The file specified in the STORE command already exists. Action: Use the REPLACE option to overwrite the existing file, or specify another file name.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0108 The names CREATE, REPLACE, APPEND, and abbreviations may not be usedCause: The file name specified was the word "file". Action: Put the name in single quotes.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0088 Missing keyword_name keyword. Usage: STORE SET filename . ext CREATE|REPLACE|APPENDCause: Missing a keyword in the statement. Action: Check the syntax of the command you used for the correct options, and use the keyword in the appropriate place.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0540 File file_name already exists. Use SAVE filename [. ext ] REPLACECause: The file specified already exists. Action: Use the REPLACE option to overwrite the existing file, or specify another file name.

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

replace optional_preference_list Rebuilds an index. You can optionally specify preferences, your own…resume [memory memsize ] Resumes a failed index operation. You can optionally specify the amount of memory to use with memsize. Note: This ALTER INDEX operation applies only to CONTEXT and CTXRULE indexes. It does not apply to CTXCAT indexes. optimize [token index_token | fast | full [maxtime (time | unlimited)]

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-28221 REPLACE not specifiedCause: User is changing password but password verification function is turned on, the original password is not specified, and the user does not have the alter user system privilege. Action: Supply the original password.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0480 A missing FROM or TO clause uses the current SQL*Plus connection Usage: COPY FROM < db > TO…, INSERT or REPLACE.: name of the destination table.: a comma-separated list of destination column

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-16202 Skip procedure requested to replace statementCause: Logical standby called a skip procedure that requested for a particular statement to be replaced with a new statement. Action: No action required; this informational statement is provided to record the event for diagnostic purposes.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-12010 This file already exists - replace existing file?Cause: Warn user of pending replacement (W3CLIB_MSG = 9). Action: The user agent client takes proper actions.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02303 cannot drop or replace a type with type or table dependentsCause: An attempt was made to drop or replace a type that has dependents. There could be a

Error Messages, 9i Release 2 (9.2.0.2)

External Naming Messages (NNF)

NNF-00516 Shows or sets the replace data used for the next modify operationCause: Test program help text. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-22871 ALTER TYPE with REPLACE is not allowed for pure incomplete typesCause: An attempt was made to perform ALTER TYPE with REPLACE option for a pure incomplete type … . Action: Completely define the original type, before using the ALTER TYPE with REPLACE option.

Error Messages, 9i Release 2 (9.2.0.2)

BFILE-Related Messages (LFI)

LFI-00121 Only one of REPLACE, or PROT allowed for opty.Cause: Both of the following open type options were specified for the LFILINI() function: LFILOPTY_REPLACE or LFILOPTY_PROT. Action: Remove one of the options so that you are only passing in one option.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-29832 cannot drop or replace an indextype with dependent indexesCause: One or more indexes are dependent upon the index type. Action: Drop all the indexes which are dependent upon the index type before dropping the index type itself.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02307 cannot alter with REPLACE option a type that is not validCause: An attempt was made to ALTER with REPLACE option a type that is not valid. Action: Use the CREATE OR REPLACE TYPE command to modify the type.