Results for FROM


1 to 60 of 29045 results. Prev  Next
Results per page:  20 | 40 |  60 


Database SQL Language Reference, 11g Release 2 (11.2)

Selecting from the DUAL Table

Selecting from the DUAL Table, DUMMY, defined to be VARCHAR2(1), and contains one row with a value X. Selecting from the DUAL table is … expression from any table, but the value will be returned as many times as there are rows in the table … . Refer to \"About SQL Functions\" for many examples of selecting a constant value from DUAL. Note … DUAL in the execution

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM with Oracle Enterprise Manager

Dropping Disks from Disk GroupsWhen you drop a disk from a disk group, Oracle ASM rebalances the disk group by moving all of the … file extents from the dropped disk to other disks in the disk group. Oracle ASM then releases the … reallocate the disk to a different storage system Note: Dropping disks from a disk group only logically … deletes the disks from

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Disk Groups

Dropping Disks from Disk Groups… ALTER DISKGROUP data2 ADD DISK '/devices/diskc3' FORCE; Dropping Disks from Disk Groups To drop disks … from a disk group, use the DROP DISK clause of the ALTER DISKGROUP statement. You can also drop all … dropped, the disk group is rebalanced by moving all of the file extents from the dropped disk to other … . You cannot

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Dropping Templates from a Disk GroupUse the DROP TEMPLATE clause of the ALTER DISKGROUP statement to drop one or more templates from a … templates. Example 7-16 drops the previously created template unreliable from data: Example 7-16 Dropping … a template from a disk group ALTER DISKGROUP data DROP TEMPLATE unreliable;

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Invoking Autonomous Functions from SQLA function invoked from SQL statements must obey rules meant to control side effects (for details … function from query DECLARE my_emp_id NUMBER(6); my_last_name VARCHAR2(25); my_count NUMBER; BEGIN … my_emp_id:= 120; SELECT debugging.log_msg(last_name) INTO my_last_name FROM employees WHERE employee_id

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Distributed Transactions

Locks from In-Doubt Transactionsportions of the two-phase commit. Even if such a failure occurs, and assuming quick recovery from a

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Performing Oracle ASM Data Migration with RMAN

Migrating a Database from Oracle ASM to Alternative StorageMigrating a database from Oracle ASM to an alternative storage system is essentially the reverse of

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Dropping Files and Associated Aliases from a Disk GroupYou can delete Oracle ASM files and their associated aliases from a disk group using the DROP FILE … file is used to delete both the file and the alias from a disk group. Example 7-7 Dropping a file and … alias from a disk group using the alias name ALTER DISKGROUP data DROP FILE '+data/payroll … file and any associated alias.

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Disk Groups

Oracle ASM Recovery from Read and Write I/O Errorsyour main concern is disk failure. For example, a disk group might be configured from several small … Oracle database environment. Oracle ASM Recovery from Read and Write I/O Errors Read errors can be … . Oracle ASM tries to recover from read errors on corrupted sectors on a disk. When a read error by … offline disk from

Database Administrator's Guide, 11g Release 2 (11.2)

Configuring Automatic Restart of an Oracle Database

Removing Components from the Oracle Restart Configurationautomatically removed from the Oracle Restart configuration. For example, if you use Database … Configuration Assistant (DBCA) to delete a database, DBCA removes the database from the Oracle Restart … removes the listener from the Oracle Restart configuration. See Table 4-3 for more examples. If you … remove the component from

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Restoring Tables from the Recycle BinUse the FLASHBACK TABLE... TO BEFORE DROP statement to recover objects from the recycle bin. You … from either the DBA_ or USER_RECYCLEBIN view as shown in \"Viewing and Querying Objects in the Recycle … . SELECT object_name, original_name, createtime FROM recyclebin; OBJECT_NAME ORIGINAL_NAME CREATETIME … $yrMKlZaVMhfgNAgAIMenRA==$0\"

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Distributed Transactions

Purging Pending Rows from the Data DictionaryBefore RECO recovers an in-doubt transaction, the transaction appears in DBA_2PC_PENDING.STATE as COLLECTING, COMMITTED, or PREPARED. If you force an in-doubt transaction using COMMIT FORCE or ROLLBACK FORCE, then the states FORCED COMMIT or FORCED ROLLBACK may appear. Automatic recovery normally deletes entries in these states. The only exception is when recovery discovers a forced transaction that

Database Administrator's Guide, 11g Release 2 (11.2)

Support for DBMS_JOB in Oracle Database 11g Release 2

Moving from DBMS_JOB to Oracle SchedulerThis section illustrates some examples of how you can take jobs created with the DBMS_JOB package and rewrite them using Oracle Scheduler, which you configure and control with the DBMS_SCHEDULER package.

Database Administrator's Guide, 11g Release 2 (11.2)

Support for DBMS_JOB in Oracle Database 11g Release 2

Removing a Job from the Job QueueThe following example removes a job using DBMS_JOB, where 14144 is the number of the job being run: BEGIN DBMS_JOB.REMOVE(14144); COMMIT; END; / Using DBMS_SCHEDULER, you would issue the following statement instead: BEGIN DBMS_SCHEDULER.DROP_JOB('myjob1'); END; / See Also: Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_SCHEDULER package Chapter 29, \"Scheduling

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Fetching from Results of Pipelined Table Functionspasses CURSOR expressions to both f and g. Example 12-31 Fetching from Results of Pipelined Table … * FROM TABLE(f(CURSOR(SELECT * FROM tab))); SELECT * BULK COLLECT INTO rec_tab FROM TABLE(g(r … )); -- NOTE: When g completes, it closes r. END; -- Second PL/SQL statement (faster): SELECT * FROM TABLE(g

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

Recovering from Permanent Media Failure Using a Control File CopyCONTROL_FILES initialization parameter. Remove the bad control file from CONTROL_FILES setting and you can

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Store Data Files Separate from Redo Log FilesData files should not be stored on the same disk drive that stores the database redo log files. If the data files and redo log files are stored on the same disk drive and that disk drive fails, the files cannot be used in your database recovery procedures. If you multiplex your redo log files, then the likelihood of losing all of your redo log files is low, so you can store data files on the same

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

Recovering from Control File Corruption Using a Control File CopyThis procedure assumes that one of the control files specified in the CONTROL_FILES parameter is corrupted, that the control file directory is still accessible, and that you have a multiplexed copy of the control file. With the instance shut down, use an operating system command to overwrite the bad control file with a good copy: % cp /u03/oracle/prod/control03.ctl /u02/oracle/prod/control02.ctl Start

Database Installation Guide for Linux, 11g Release 2 (11.2)

Oracle Database Postinstallation Tasks

5.4.1 Migrating User Settings from Release 1.0asked to migrate your user settings from a previous release. (This occurs regardless of whether … there was a previous release on your system.) Note: Migration of user settings is supported only from … SQL Developer release 1.0 to release 1.1. It is not supported for migration from a prerelease version … migrate your user settings

Database Installation Guide for Linux, 11g Release 2 (11.2)

Oracle Database Postinstallation Tasks

5.4.2 Migrating Information from Previous ReleasesNavigator and selecting Import Connections. To use any user-defined reports or the SQL history from a … located. To use any user-defined reports or the SQL history from release 1.0 with both releases 1.0 … and then Preferences ) from a prerelease version of the current release cannot currently be saved and reused; you must provide any

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Maintaining RMAN Backups and Repository Records

Removing Records from the RMAN RepositoryThis section explains how to remove records for files from the RMAN repository. About Uncataloging … backup record from the recovery catalog (if you use one) RMAN does not change the specified physical … with an operating system utility, then remove the record for this log from the repository by issuing a … you deleted from

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Starting and Interacting with the RMAN Client

Making Database Connections from the RMAN Promptdatabase connection from the RMAN prompt: On the operating system command line, start the RMAN

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed TablespaceUse the TABLESPACE_MIGRATE_TO_LOCAL procedure to migrate a dictionary-managed tablespace to a locally managed tablespace. This operation is done online, but space management operations are blocked until the migration has been completed. Therefore, you can read or modify data while the migration is in progress, but if you are loading a large amount of data that requires the allocation of additional

Database Performance Tuning Guide, 11g Release 2 (11.2)

Using Plan Stability

20.2.1 Moving from RBO to the Query Optimizerthe application when upgrading from rule-based to query optimization. By creating outlines for an … which outlines are to be created have the CREATE ANY OUTLINE privilege. For example, from SYS: GRANT

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Managing a Recovery Catalog

Unregistering a Target Database from the Recovery CatalogYou can use the UNREGISTER DATABASE command to unregister a database from the recovery catalog … . When a database is unregistered from the recovery catalog, all RMAN repository records in the recovery … existing backups. Do not delete all backups if your intention is only to remove the database from … the process is complete,

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing RMAN Recovery: Advanced Scenarios

Restoring the Server Parameter File from a Control File Autobackupthe control file whenever an autobackup is taken. To restore the server parameter file from the … FROM AUTOBACKUP command. If the autobackup is in a nondefault format, then first use the SET … server parameter file from a control file autobackup in a nondefault location. Example 20-1 Restoring … the Server Parameter File from

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Tuning RMAN Performance

Step 1: Remove the RATE Parameter from Channel Settingsin a RUN command, then remove the RATE parameter, if it is specified, from the ALLOCATE command … configured settings. Remove the RATE parameter, if it is set, from the CONFIGURE CHANNEL command.

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing User-Managed Recovery: Advanced Scenarios

Recovering from a Dropped Table Without Using Flashback FeaturesOne common error is the accidental dropping of a table from your database. In general, the fastest … before the table was dropped. Export the lost data from the temporary, restored version of the

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Starting and Interacting with the RMAN Client

Making RMAN Database Connections from the Operating System Command LineTo connect to a target database from the operating system command line, enter the rman command

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Managing a Recovery Catalog

Revoking Privileges from a Virtual Private Catalog Ownerto register databases in his virtual private catalog. Now you want to revoke privileges from vpc1. To … revoke privileges from a virtual private catalog owner: Start RMAN and connect to the recovery … ; Revoke specified privileges from the virtual private catalog owner. The following command revokes … access to the metadata for

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Configuring the RMAN Environment: Advanced Topics

Configuring Tablespaces for Exclusion from Whole Database BackupsSometimes you may want to omit a specified tablespace from part of the regular backup schedule … different schedule from other backups. You can run CONFIGURE EXCLUDE FOR TABLESPACE to exclude the … specified tablespace from the BACKUP DATABASE command. The exclusion condition applies to any data … cwmlite and example from

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

SQL*Net message from dblinklink from another server process. Wait Time: The time it took for a message to arrive from another … process) from another foreground process over a database link. See Also: Oracle Database Performance Tuning Guide for more information about this wait event

Database Utilities, 11g Release 2 (11.2)

Loading Objects, LOBs, and Collections

Loading LOB Data from LOBFILEsLOB data can be lengthy enough so that it makes sense to load it from a LOBFILE instead of from a … a LOB from a LOBFILE fit in memory. SQL*Loader reads LOBFILEs in 64 KB chunks. In LOBFILEs the data … , TERMINATED BY or ENCLOSED BY ) The clause PRESERVE BLANKS is not applicable to fields read from a LOBFILE

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

SQL*Net message from clientThe server process (foreground process) waits for a message from the client process to arrive. Wait … Time: The time it took for a message to arrive from the client since the last message was sent to … the server (foreground process) from the client. See Also: Oracle Database Performance Tuning Guide for more information about this wait

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Data Retrieval MechanismsData retrieval from the SAP system can be \"Completely Managed by Oracle Warehouse Builder … RFC_ABAP_INSTALL_AND_RUN, and to use FTP to import the generated data file from the SAP system. Thus the entire … process of retrieving data from the SAP system and creating a target table is managed by the Oracle

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Defining the SAP Extraction MappingYou can use the Mapping Editor to create a mapping containing SAP tables. Creating a mapping with SAP tables is similar to creating mappings with other database objects. However, there are restrictions on the operators that can be used in the mapping. You can only use table, filter, joiner, and mapping input parameter mapping operators in a mapping containing SAP tables. A typical SAP extraction mapping

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.3.1 Install the Oracle Database and Complete Pre-installation TasksOracle Application Express requires an Oracle database that is release 9.2.0.3 or later. To learn more, see the Oracle Database Installation Guide for your operating environment and \"Recommended Pre-installation Tasks\".

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.4.5 Configure Oracle HTTP Server Distributed with Oracle Database 11g or Oracle Application Server…installation. Tip: If you are upgrading from a prior release of Oracle Application Express, this step … configuring the database access descriptor (DAD) in a new installation. Tip: If you are upgrading from a … Copy the Images Directory Whether you are loading a new installation or upgrading from a previous … release, you must

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.4.10 About Managing JOB_QUEUE_PROCESSESApplication Express From SQL*Plus 3.4.10.1.1 Viewing JOB_QUEUE_PROCESSES in the Installation Log File … bottom of the page. 3.4.10.1.3 Viewing JOB_QUEUE_PROCESSES from SQL*Plus You can also view the number … of JOB_QUEUE_PROCESSES from SQL*Plus by running the following SQL statement: SELECT VALUE FROM v

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.2 Choosing an HTTP ServerIn order to run, Oracle Application Express must have access to either the embedded PL/SQL gateway or Oracle HTTP Server and mod_plsql. To learn more, see \"About Choosing an HTTP Server\".

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.3.3 Change the Password for the ADMIN Accountupgrade scenario, the password will be preserved and carried over from the prior release. To change the

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.4 Downloading from OTN and Configuring Oracle HTTP ServerThis section describes how to install Oracle Application Express by downloading a ZIP file from OTN

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.4.6 Enable Network Services in Oracle Database 11g: Sending outbound mail in Oracle Application Express. Users can call methods from the APEX_MAIL … properly, but a database upgraded to 11 g from a prior version may not. See \"Creating and Configuring an … privilege yet. SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS WHERE HOST = '*' AND LOWER_PORT IS NULL AND … \"XDB.DBMS_XDBZ\",

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.4.11 About Obfuscating PlsqlDatabasePassword ParameterThe PlsqlDatabasePassword parameter specifies the password for logging in to the database. You can use the dadTool.pl utility to obfuscate passwords in the dads.conf file. You can find the dadTool.pl utility in the following directory: For UNIX and Linux based systems: ORACLE_BASE/ORACLE_HTTPSERVER_HOME/Apache/modplsql/conf For Windows based systems: ORACLE_BASE\\ORACLE_HTTPSERVER_HOME\\Apache\\modplsql\\conf

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.6 About the Oracle Application Express Runtime EnvironmentThe Oracle Application Express runtime environment enables users to run a production application without supporting the ability to change or edit the application. It includes only the packages necessary to run your applications, making it a more hardened environment. It does not provide a Web interface for administration. You administer the Oracle Application Express runtime environment using SQL*Plus

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

SAP Object Types: Transparent: A transparent table is a database table that stores data. You can access the table from

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Analyzing Metadata DetailsWith SAP tables, you cannot view the data after you import the metadata from these tables. However

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Creating SAP Extraction Mappingsnames. To view the business names for tables in Oracle Warehouse Builder, from the main menu, click … SAP Extraction Mappings After importing metadata from SAP tables, you must define the extraction … mapping to extract data from the SAP system. Note: For details of mappings in Oracle Warehouse Builder

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.3.12 Create a Workspace and Add Oracle Application Express Users… For Re-use existing schema, select Yes. Select a schema from the list. Click Next. For Identify … configuration file. For users who have upgraded from earlier releases, or who have a custom

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.5.1 Remove Prior Oracle Application Express InstallationsThe database users associated with schemas from prior installations are privileged users and should … be removed when they are no longer necessary. Removing schemas from a prior installation is a two … query: SELECT username FROM dba_users WHERE (username LIKE 'FLOWS_%' OR USERNAME LIKE 'APEX_%') AND … USERNAME NOT IN ( SELECT

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.6.1 Converting a Runtime Environment to a Full Development EnvironmentTo convert an Oracle Application Express runtime environment to a full development environment: Change your working directory to the apex directory where you unzipped the installation software. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example: On Windows: SYSTEM_DRIVE:\\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Why SAP Connectorcluster tables. These tables contain multiple physical tables and must be managed differently from

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Supported SAP VersionsFor information about the SAP R/3 versions supported by Oracle Warehouse Builder 11 g, log in to https://support.oracle.com/, and go to the Certify link.

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Importing Metadata from SAP TablesAfter you establish a connection with the SAP server, you can import metadata from SAP tables. This

Warehouse Builder Sources and Targets Guide, 11g Release 2 (11.2)

Extracting Data from SAP Applications

Automated Systemdirectly from the SAP system without being dependent on the SAP administrator, as shown in Figure 7-4.

Application Express Application Builder User's Guide, 11g Release 2 (11.2)

Sending Email from an Application

Sending Email from an ApplicationThis section describes how to send email from an Oracle Application Express application. Topics in … this section include: About Configuring Oracle Application Express to Send Email Sending Email from

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.1 Recommended Pre-installation Tasksfrom the Administrative Tools menu (under Start and then Programs ), to shut down Oracle Database … . Right-click the name of the service and from the menu, choose Stop. Back up the Oracle Database

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.3.7 Enable Indexing of Online Help in Oracle Database 11g Release 2 and HigherSYSDBA Enter password: SYS_password Run the following command: SELECT par_value FROM

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.3.9 About Running Oracle Application Express in Other LanguagesExpress Whether you are installing for the first time or upgrading from a previous release, you must run

Application Express Installation Guide, 11g Release 2 (11.2)

Downloading from Oracle Technology Network

3.4.1 Install the Oracle Database and Complete Pre-installation TasksOracle Application Express requires an Oracle database that is release 9.2.0.3 or later. To learn more, see the Oracle Database Installation Guide for your operating environment and \"Recommended Pre-installation Tasks\".





Was this page helpful?

Integrated Cloud Applications & Platform Services