Results for FROM


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


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

Downloading from Oracle Technology Network

3.4.8 Security ConsiderationsOracle highly recommends you configure and use Secure Sockets Layer (SSL) to ensure that passwords and other sensitive data are not transmitted in clear text in HTTP requests. Without the use of SSL, passwords could potentially be exposed, compromising security. SSL is an industry standard protocol that uses RSA public key cryptography in conjunction with symmetric key cryptography to provide authentication,

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

Extracting Data from SAP Applications

7 Extracting Data from SAP Applicationsextract data from SAP systems. It describes why you require an SAP connector, how to import metadata from … system. The chapter also describes the various methods by which you can extract data from the SAP … Retrieval Mechanism\" \"Connecting to the SAP System\" \"Importing Metadata from SAP Tables

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

Extracting Data from SAP Applications

Overview of the Interaction Between Oracle Warehouse Builder and SAPMoving data from the SAP system to an Oracle database using Oracle Warehouse Builder consists of … the following tasks: Connecting to the SAP system. Importing metadata from SAP data objects. Creating … an extraction mapping in Oracle Warehouse Builder that defines: The SAP source tables from which … from the

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

Extracting Data from SAP Applications

Creating SAP Module DefinitionsUse the Create Module Wizard to create the SAP source module that stores data from the SAP source … from an existing location or click Edit to open the Edit SAP Location dialog box. Specify the details … . Obtain these details from the system administrator. When you set the connection information, you … information for your SAP

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

Extracting Data from SAP Applications

Importing SAP Metadata DefinitionsAfter creating the SAP source module, you can import metadata definitions from SAP tables using the … tables. To import SAP metadata: From the Projects Navigator, expand the Applications node. Right-click … obtain matching tables from the SAP data source. The Description matches field is case sensitive, the … the tables you want

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

Extracting Data from SAP Applications

Manual Systemand use it in your mapping to extract data from the production environment. Before you run the … on the SAP system from where data is extracted. Data File Name: Name of the data file to store the … module name from the SAP administrator. FTP Directory: A directory on the SAP system. The data file … server. Oracle Warehouse Builder

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 Application Builder User's Guide, 11g Release 2 (11.2)

Sending Email from an Application

About Configuring Oracle Application Express to Send EmailBefore you can send email from an Application Builder application, you must: Log in to Oracle

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

Downloading from Oracle Technology Network

3.3.2 Download and Install Oracle Application ExpressTo install Oracle Application Express: Download the file apex_3.2.zip from the Oracle Application … are upgrading from a previous release, FLOWS_FILES, already exists and APEX_PUBLIC_USER is created if … it does not already exist. Tip: Oracle Application Express must be installed from a writable

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

Downloading from Oracle Technology Network

3.3.10 About Managing JOB_QUEUE_PROCESSESApplication Express From SQL*Plus 3.3.10.1.1 Viewing JOB_QUEUE_PROCESSES in the Installation Log File … bottom of the page. 3.3.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.3.11 Configuring the SHARED_SERVERS ParameterThe embedded PL/SQL gateway uses the shared server architecture of the Oracle Database. To achieve acceptable performance when using the embedded PL/SQL gateway, ensure the SHARED_SERVERS database initialization parameter is set to a reasonable value (that is, not 0 or 1 ). For a small group of concurrent users, Oracle recommends a value of 5 for SHARED_SERVERS. Consider the following example: Start

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

Downloading from Oracle Technology Network

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

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

Extracting Data from SAP Applications

Implementing the SAP Data Retrieval Mechanismextract data from an SAP system. Because the SAP and Oracle Warehouse Builder systems are totally … administrator to extract data from the system. Access privilege to the SAP system is most often … details of the tasks involved in retrieving data from an SAP system: \"Connecting to the SAP System … \" \"Importing Metadata from

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

Extracting Data from SAP Applications

Deploying and Executing SAP ABAP Mappings… You can also deploy the mapping from Control Center Manager. For detailed information about … the database home. Depending on whether data retrieval from the SAP system is fully automated, semi

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

Extracting Data from SAP Applications

Semi-Automated Systemthe ABAP code generated for the mapping. SAP Location: The location on the SAP system from where data … the file from this directory to the Oracle Warehouse Builder system. This requires an FTP server to … \"Remote Function Call (RFC)\". In the SAP system, the ABAP report extracts data from the source … Warehouse Builder loads

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

Extracting Data from SAP Applications

Connecting to the SAP SystemTo connect to the SAP system from Oracle Warehouse Builder, you must use certain SAP-specific DLL … files. After you establish connection, you can then import metadata from SAP tables into SAP modules

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

Extracting Data from SAP Applications

Table 7-4 SQL*Loader Code Generated in ABAPmapping, the input parameter holds a date value, and the data from table BKPF is filtered based on this … mapping is run. The joiner operator enables you to join data from multiple tables, and the combined … from the Loading Type list. With ABAP code as the language for the mapping, the SQL*Loader code is … location of the SAP

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

Downloading from Oracle Technology Network

3.3 Downloading from OTN and Configuring the Embedded PL/SQL GatewayThis 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.3.8 Security ConsiderationsOracle highly recommends you configure and use Secure Sockets Layer (SSL) to ensure that passwords and other sensitive data are not transmitted in clear text in HTTP requests. Without the use of SSL, passwords could potentially be exposed, compromising security. SSL is an industry standard protocol that uses RSA public key cryptography in conjunction with symmetric key cryptography to provide authentication,

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

Downloading from Oracle Technology Network

3.5 Post Installation Tasks for Upgrade Installationsfunction properly, you should remove schemas from prior Oracle Application Express installations

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

Downloading from Oracle Technology Network

3.5.2 Fix Invalid ACL in Oracle Database 11gAfter following the instructions in \"Remove Prior Oracle Application Express Installations\", you may need to fix an invalid ACL if you are running Oracle Database 11 g and you enabled network services for the prior Oracle Application Express schema. To fix an invalid ACL: Change your working directory to the apex directory where you unzipped the installation software. Start SQL*Plus and connect

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

Extracting Data from SAP Applications

SAP Business Domainssource application. This navigation tree enables you to select SAP tables from the SAP application server.

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

Extracting Data from SAP Applications

Required Files for SAP Connectorfiles. The correct versions are available in the SAP installation CD. The files can also be downloaded from: http://service.sap.com/patches

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

Downloading from Oracle Technology Network

3 Downloading from Oracle Technology NetworkThis chapter describes how to install Oracle Application Express by downloading a ZIP file from … in this chapter apply to both new and upgrade installations. To learn more, see \"Upgrading from a … Pre-installation Tasks Choosing an HTTP Server Downloading from OTN and Configuring the Embedded PL … /SQL Gateway Downloading from

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

Downloading from Oracle Technology Network

3.3.5 Configure the Embedded PL/SQL Gatewayapex_epg_config.sql Configuration Script Updating the Images Directory When Upgrading from a Previous … embedded PL/SQL gateway, skip this section and go to \"Updating the Images Directory When Upgrading from a … Directory When Upgrading from a Previous Release If you are upgrading Oracle Application Express … from

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

Downloading from Oracle Technology Network

3.3.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.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

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

Extracting Data from SAP Applications

Overview of SAP ObjectsThis section provides a brief overview of the different types of tables in SAP, and how data is organized within an SAP system. The section consists of the following topics: \"SAP Object Types\" \"SAP Business Domains\"

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

Extracting Data from SAP Applications

SAP Function ModulesTo access SAP data from non-SAP systems, you typically use a function module to execute an ABAP … then be called from any ABAP program. SAP contains a predefined function module called

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

Extracting Data from SAP Applications

Troubleshooting Connection Errorslibrfc32.dll file. Download the correct version of the DLL file from the SAP Web site.

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

Downloading from Oracle Technology Network

3.3.4 Restart ProcessesAfter you install Oracle Application Express, you must restart the processes that you stopped before you began the installation, such as listener and other processes.

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

Downloading from Oracle Technology Network

3.4.2 Download and Install Oracle Application ExpressTo install Oracle Application Express: Download the file apex_3.2.zip from the Oracle Application … are upgrading from a previous release, FLOWS_FILES, already exists and APEX_PUBLIC_USER is created if … it does not already exist. Tip: Oracle Application Express must be installed from a writable

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

Downloading from Oracle Technology Network

3.4.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.12 Create a Workspace and Add Oracle Application Express Usersschema from the list. Click Next. For Identify Administrator, enter the Workspace administrator … database access descriptor (DAD) defined in the configuration file. For users who have upgraded from

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

Downloading from Oracle Technology Network

3.6.2 Converting a Full Development Environment to a Runtime EnvironmentTo convert an Oracle Application Express full development environment to a runtime 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

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

Sending Email from an Application

Sending Email from an ApplicationYou can send an email from an Application Builder application by calling the PL/SQL package … sending email: Use APEX_MAIL.SEND to manually send an outbound email mess age from your application Use … APEX_MAIL.ADD_ATTACHMENT to send an outbound email message from an application as an attachment

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

Oracle Database Preinstallation Tasks

2.1.6 Installing the Oracle Preinstallation RPM from DVD Disks or ImagesUse the following procedure to install the Oracle Preinstallation RPM or Oracle Validated RPM fromfrom Oracle Store, or downloading disk images from the Oracle Software Delivery Cloud portal for … box from the package list, and click Next. Complete the other screens to finish the Oracle Linux

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

SQL Access Advisor

Step 2   Load the SQL tuning set from the user-defined table SH.USER_WORKLOAD) AS ROW FROM user_workload; DBMS_SQLTUNE.LOAD_SQLSET(:workload_name,:sqlsetcur); END;

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

SQL Access Advisor

Step 3   Load the SQL tuning set from the user-defined table SH.USER_WORKLOAD, 0,0,0,0) AS ROW FROM USER_WORKLOAD; DBMS_SQLTUNE.LOAD_SQLSET(:workload_name, sqlset_cur); END;

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

Using SQL Plan Management

To import a set of SQL plan baselines from one system to another: ( table_name => 'stage1'); END; / Pack the SQL plan baselines you want to export from the SQL management … system. Import the staging table stage1 from the flat file using the Oracle Data Pump Import utility … . Unpack the SQL plan baselines from the staging table into the SQL management base on the target

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

SQL Access Advisor

Step 5   Load the SQL tuning set from the user-defined table SH.USER_WORKLOAD) AS row FROM user_workload; DBMS_SQLTUNE.LOAD_SQLSET(:workload_name, sqlsetcur); END;

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

Duplicating a Database: Advanced Topics

Table 25-2 Results from Example 25-3 SET NEWNAME DATABASE CommandBefore SET NEWNAME DATABASE Tablespace Name Data File File Number After SET NEWNAME DATABASE TO '/oradata/%U';.../system01.dbf SYSTEM 1 /oradata/data-D-PROD_id-87650928_TS-SYSTEM_FNO-1.../sysaux01.dbf SYSAUX 2 /oradata/data-D-PROD_id-87650928_TS-SYSAUX_FNO-2.../undotbs01.dbf UNDOTS 3 /oradata/data-D-PROD_id-87650928_TS-UNDOTS_FNO-3.../users01.dbf USERS 4 /oradata/data-D-PROD_id-87650928_TS-USERS_FNO-4.../users02.dbf

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

SQL*Net more data from dblinkThe foreground process is expecting more data from a data base link. Wait Time: The total time it … takes to read the data from the database link (including the waiting time for the data to arrive

Database Upgrade Guide, 11g Release 2 (11.2)

Upgrading to the New Release of Oracle Database

Configuring the Listener When Upgrading from Oracle9iIf you are upgrading from Oracle9 i and a listener was not configured in the Oracle9 i repository … Oracle RAC database with DBUA, which automatically migrates the listener from your old Oracle home to the … infrastructure home. Do not attempt to use the lsnrctl commands from Oracle home locations for previous releases … . If

Database Upgrade Guide, 11g Release 2 (11.2)

Downgrading Oracle Database to an Earlier Release

Downgrading and Database Links from Earlier Releasescreated while running the new release from which you are downgrading. Knowing the database link

Database Data Warehousing Guide, 11g Release 2 (11.2)

Physical Design in Data Warehouses

Moving from Logical to Physical DesignLogical design is what you draw with a pen and paper or design with Oracle Warehouse Builder or Oracle Designer before building your data warehouse. Physical design is the creation of the database with SQL statements. During the physical design process, you convert the data gathered during the logical design phase into a description of the physical database structure. Physical design decisions are

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

Installation Guide

4.3.1 Installing from a Remote DVD Driveperform the installation from a remote DVD drive. You must complete the following steps: Step 1: On the … run Oracle Universal Installer from the mapped drive: Map the remote DVD drive. Start Windows Explorer … on the local computer. From the Tools menu, select Map Network Drive to display the Map Network … Finish. Run Oracle

Database Utilities, 11g Release 2 (11.2)

Original Export

Exporting From a Read-Only DatabaseTo extract metadata from a source database, Export uses queries that contain ordering clauses (sort

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Revoking Privileges and Roles from a UserThis section contains: Revoking System Privileges and Roles Revoking Object Privileges Cascading Effects of Revoking Privileges

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Assembling Logical Records from Physical RecordsAs of Oracle9 i, user-defined record sizes larger than 64 KB are supported (see \"READSIZE (read buffer size)\" ). This reduces the need to break up logical records into multiple physical records. However, there may still be situations in which you may want to do so. At some point, when you want to combine those multiple physical records back into one logical record, you can use one of the following

Database Backup and Recovery Reference, 11g Release 2 (11.2)

RESTORE

Table 3-10 RESTORE ... FROM AUTOBACKUPtypical, then RMAN verifies the checksum when restoring from the backup and writing to the data file. If … information does not match the information in the control file. FROM BACKUPSET Specifies that RMAN … should restore from backup sets only. By default RESTORE chooses the file copy or backup set that … needs the least media

Database Data Warehousing Guide, 11g Release 2 (11.2)

Data Warehousing Concepts

Extracting Information from a Data WarehouseYou can extract information from the masses of data stored in a data warehouse by analyzing the

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

SQL*Net more data from client(including the waiting time) Parameter Description driver id See \"driver id\" #bytes The number of bytes received from the client

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

Configuration Tasks When Installing from the Database

4.3 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)

Configuration Tasks When Installing from the Database

4.4.2 Configure the Embedded PL/SQL Gatewaythe following statement to verify the port number: SELECT DBMS_XDB.GETHTTPPORT FROM DUAL; If the

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

Configuration Tasks When Installing from the Database

4.5.2 Configure Oracle HTTP Server Distributed with Oracle Database 11g or Oracle Application Server…Express that installs with Oracle Database 11 g or later. You re not upgrading from a previous release … upgrading from a prior release of Oracle Application Express, this step is unnecessary. To change the … are loading a new installation or upgrading from a previous release, you must copy the images … directory from

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

Configuration Tasks When Installing from the Database

4.5.6 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

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Obtaining Data from an OracleDataReader Object

Obtaining LONG and LONG RAW DataODP.NET fetches and caches rows from the database during the Read method invocations on the … OracleDataReader object. The amount of LONG and LONG RAW column data that is retrieved from this operation

XML DB Developer's Guide, 11g Release 2 (11.2)

Generating XML Data from the Database

18 Generating XML Data from the DatabaseThis chapter describes Oracle XML DB features for generating (constructing) XML data from … functions and packages for generating XML data from relational content. This chapter contains these … topics: Overview of Generating XML Data From Oracle Database Generating XML using SQL Functions

XML DB Developer's Guide, 11g Release 2 (11.2)

Generating XML Data from the Database

Table 18-1 DBMS_XMLGEN Functions and Procedureshandle that you can use in the getXML and other functions to get the XML back from the result … . newContext( queryString IN SYS_REFCURSOR) RETURN ctxHandle; Creates a new context handle from a PL/SQL … getXML and other functions to get a hierarchical XML with recursive elements back from the result … IN ctxHandle, rowTag IN VARCHAR2);





Was this page helpful?

Integrated Cloud Applications & Platform Services