Why oracle 10g

In a side note, in the project install guide, I am supposed to run "sqlplus system xe" after Oracle is installed. Each questions about that error was about "it worked fine for a week and now no more" which is clearly not my situation, so this is not my question, just a side note.

One of my teammate found the answer. The problem was in the installation and here is what worked:. Warning for Windows7 only : Oracle 10g installation on windows 7 bit completes without error but it is incomplete. In order to fix the problem, before installing Oracle, shut down your PC, unplug your network cable, boot your PC and install Oracle not a joke , and reconnect only after the installation of Oracle 10g.

Those are the only two services you need, and it does sound like the OracleServiceXE may not be running. From a command prompt, run netstat -an and see if anything is listening on port I've seen it get installed on alternate ports including in the past. If there's something on , try that. Replace mypassword with that your SYS user password as specified during the installation process. Note that the number 2, 3, 4 at the left side is generated by the sqlplus tools prompt you don't need to type them in.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Oracle 10g express and 11g express DB homepage is not showing up Ask Question. Asked 10 years ago.

Active 4 years, 6 months ago. Viewed 14k times. Check out the enhancements here. If you are not currently using this tool you're running out of excusses. Server Configuration in Oracle Database 10g - Oracle 10g includes some changes relating to basic server configuration which are relevant to the OCP upgrade exam. Space, Object, and Transaction Management in Oracle Database 10g - A description of the new features relating to space, object and transaction management in Oracle 10g.

SQL Access Advisor in Oracle Database 10g - Use this advisor to get suggestions for indexes and materialized views that might help system performance. Tablespace Management Enhancements in Oracle Database 10g - Oracle 10g includes several small but neat enhancements related to tablespace management.

Upgrading to Oracle Database 10g - This article provides a brief overview of the areas involved in upgrading existing databases to Oracle 10g. Index Monitoring - Identify and remove unused indexes to improve performance. The addition of Stacked Bar charts allow visualizing of cumulative data in bar charts that was previously not possible. SVG charts can now be configured to refresh at an interval defined by the developer.

The refresh causes the chart to rerun the query upon which its data set is based. The Master Detail wizard creates a master detail mini-application divided into either 2 or 3 pages with the following features:. The Master Detail wizard automates the manual steps previously required to build a master detail form. The Create Application wizard has been enhanced in two ways. First, it now enables you to create an application on spreadsheet data.

Previously, importing of spreadsheet data had to be done in a separate step using the Data Workshop. This task has now been integrated into the wizard. Secondly, the generated application both on imported spreadsheet data and on an existing table has more features. Those features include:. The enhanced Create Application wizard simplifies the process of creating an application based on spreadsheet data and generates a more feature rich application.

With the enhanced Web Services wizard, you can create forms that invoke web services and reports based on the results returned by the web service. The enhancements to the Web Services wizard allow you to incorporate web services in an application without any programming. Specifically, a large number of options have been removed or reorganized to eliminate confusion. Additionally, commonly used tasks such as Run Application or Edit Application have moved to improve consistency. Conditional compilation to allow automatic selection of source code according to the version of Oracle Database.

A new Web Gateway to allow the Oracle instance itself to respond directly to an HTTP request with a response generated by a stored procedure. The benefit is that one body of source code can be deployed in a range of Oracle Database versions to take advantage of new features where they are available and to use fallback approaches where they are not. Debugging and tracing code can be left in place without penalizing the size of the executable or runtime efficiency.

Such code can be easily activated by a simple recompilation. WRAP input command. The command-line WRAP utility, available in Oracle Database 10 g Release 1 and earlier, allowed the code that a vendor shipped to be obfuscated. This new feature allows custom code generated by shipped vendor code to be obfuscated.

In this case, NULL means "unlimited. In Release 2, the line length limit is increased to 32, bytes and the overall limit is removed altogether. C and Fortran APIs for matrix math are freely available. Moreover, efficient platform-specific implementations have been written for many of the most popular platforms.

This required substantial programming effort and the performance of the resulting implementation was limited. Rules Manager for Expression Filter can manage and evaluate an unlimited number of rules, provide efficient synchronization of multiple events and threads, and support a single management environment for rules and application data. Rules Manager is a new feature of Oracle Database 10 g Release 2.

It enables developers to create applications that process and respond to events of any complexity using rules and policies defined in the database. It can evaluate events using data from the application and from database tables. It stores intermediate results to quickly evaluate the next event in a long running composite event an event made up of two or more simple events.

Rules are defined using XML and SQL and can have complex conditions using conjunctions and disjunctions, and specify a set of events, time, and non-occurrence of events with or without a deadline. Event policies control how rules are processed and the duration of an event. Rules can trigger actions that are user-defined procedures running inside an Oracle Database or actions in another application. The benefit of this feature is that rules that are managed in Oracle Database keep pace with changing business conditions and are always up-to-date; rules are easily changed with SQL and are not included in your application or loaded into a memory-based rules repository.

Rules can be evaluated efficiently with the complete business context stored in your Oracle Database and data provided by your application. Event response is flexible; rules can trigger actions in Oracle Database or your application. Performance, by evaluating rules and coordinating multiple events and application threads with the full capabilities of Oracle Database.

Oracle's SQL Regular Expression provides a simple yet powerful mechanism for rapidly describing patterns and greatly simplifies the way in which you search, extract, format, and otherwise manipulate text in the database.

Collection operators operate on collections of data objects. Distributed LOBs support provides easy-to-use and efficient support for accessing unstructured data in a distributed environment.

Allowing users to collect statistics on a set of XPath expressions stored in a table to create an optimal Expression Filter index structure. Expression Filter features for Oracle Database 10 g Release 2 include better usability and improved performance. You can specify default values for expression attributes and specify name spaces in XPath expressions.

This enables developers to use existing XDK-based applications directly with the database thus improving performance. Its customization feature enables modification of Java classes to speed development and reduce support costs. This feature reduces the number of conditions under which XPath Rewrite does not occur.

The net effect is that applications using these constructs run faster without any recoding. It cannot be used to add or remove nodes from a document. This feature resolves this issue by introducing a family of SQL functions similar to UpdateXML that make it possible to add and remove nodes from a document. This feature improves programmer productivity by providing functions that make it possible to perform complex operations on the content of XML documents directly from SQL.

Typically, these functions reduce the number of statements required to perform a particular operation when compared to typical DOM-based operations. This new set of functions also improves application performance by allowing more complex manipulation of XML content to be performed by XPath Rewrite.

These new functions improve application performance by allowing complex operations on XML documents to be performed using XPath Rewrite. Implementation of the SOAP 1. The customization feature enables modification of Java classes to speed development and reduce support costs. This feature improves the performance and range of applications for style sheets and XQuerys.

This reduces the need for compiled code, easing development and maintenance. Once the XML Schema has been defined, application developers can create richer content management applications by adding customer metadata to the standard metadata recorded by the Oracle XML DB repository. This feature makes better use of information contained in documents by making it possible to associate custom metadata with documents stored in the Oracle XML DB repository.

This metadata improves your ability to classify, organize, manage, process, and search the vital corporate information stored in documents. The benefit of this new feature is that it allows the Transportable Tablespace feature of Oracle Database to be used to move tablespaces containing schema-based XMLType tables and columns from one database to another.

Oracle Database Administrator's Guide for details. The following sections describe Availability features for Oracle Database 10 g Release 2. In Oracle Database 10 g Release 2, Oracle Data Guard offers a compelling set of capabilities that provide unparalleled levels of data availability, data protection, and data recovery.

For example, on an outage of the primary server, site, or network, the new Fast-Start Failover feature allows Data Guard to rapidly and automatically fail over to the standby database, without requiring manual intervention.

This significantly improves the degree of high availability as well as the disaster resilience for the system infrastructure. On a failure or outage of the primary server or site, or of the network, Data Guard can now rapidly and automatically fail over to a previously chosen standby database, without requiring manual intervention.

The benefit of fast-start failover is that it increases the degree of high availability, as well the robustness of disaster recovery, for the system infrastructure. It also reduces manual operations, thereby reducing management costs. Oracle Data Guard Broker for details.

After a failover, this feature allows the old primary database to be automatically reinstated as a standby database, without requiring re-creation of the primary, or manually performing the Flashback Database operation.

This feature is supported only for synchronous redo transports that enabled zero data loss that is, Maximum Protection and Maximum Availability modes. It also requires Flashback Database to be enabled on both the primary and target standby databases. It is also possible to do this conversion using a single command or a simple push-button interface through Enterprise Manager.

The benefit of this feature is that it enables the Data Guard configuration to easily restore disaster protection in the configuration, without complex manual steps, improving the robustness of the disaster recovery features of Data Guard, as well as improving Data Guard manageability. Asynchronous redo transmission using the log writer process is no longer limited by the size of the network buffer.

The log writer process is no longer blocked on network time outs during asynchronous redo transmission. This allows a greater number of archiver processes to archive redo logs remotely.

The benefit of this feature is that it reduces any effect on the primary database during asynchronous redo transmission. It allows faster redo transmission to standby databases for bulk batch updates on the primary database. This feature allows the user to activate a physical standby database that is, fail over to a primary database that has never been opened read-only, without doing a database restart.

The benefit of faster Redo Apply failover is that it enables customers to recover from a failure or outage much faster, increasing the degree of high availability of the system. Oracle Data Guard Concepts and Administration for details. Failover to a logical standby database can now be completed much faster. It is no longer necessary to restart SQL Apply as part of the failover operation. The benefit of faster SQL Apply failover is that it enables recovery from a failure or outage much faster, increasing the degree of high availability of the system.

Oracle Database 10 g Release 2 introduces database transport across the same Endian platforms which provides a fast and easy way to transport the whole database across platforms with the same Endian format. This feature uses RMAN to quickly convert the datafiles and create the new database.

This transport feature provides a fast method to move a database from one platform to another. The ability to migrate databases from one platform to another has become more important for Oracle customers. Oracle Data Pump can export the entire database, but it may be time consuming because it uses the SQL layer to process data. Database transport across the same Endian platforms provides a faster and easier way to move Oracle databases from one platform to another.

Oracle Database 10 g Release 2 continues to enhance the built-in database features for recovery and testing operations to be expeditious, simple, and automatic. In this release, Data Guard has also optimized the network transmission of redo data, enabling standby databases to be synchronized with the primary database at a faster rate than in previous releases, with minimal effect on the primary database.

Similarly, Data Guard has considerably improved its manageability and ease-of-use compared to previous releases, allowing administrators to monitor the state and performance of the disaster recovery configuration at a higher granular level.

This feature allows a DBA to:. Generate a tablespace set from the source database and plug it into the target database, essentially automating movement of tablespaces between the databases. Plug-in the tablespace set provided by the user into the target database and perform an import operation. Using this tool, database administrators can automate the process of transporting tablespaces across databases. Tablespaces can be transported between databases running on different platforms using different supported versions.

This user-friendly tool performs checks and validations, which are needed to ensure valid and compatible tablespace sets for plugging into the target databases. Similarly, Streams can be used for replication of a broader range of data types. Oracle Database Utilities for details. Archived logs, once they are applied on the logical standby database, will be automatically deleted by SQL Apply.

This feature reduces storage consumption on the logical standby database and improves Data Guard manageability. This feature deprecates unnecessary initialization parameters and attributes for Oracle Database 10 g Release 2.

This feature simplifies the usage of initialization parameters and attributes, as well as certain SQL statements. This is similar to dynamic RMAN channel allocation for a single instance. It also provides better tolerance of media failures that is, when one node fails, another node can continue backup work. RMAN now creates encrypted backups that cannot be restored by unauthorized people.

There are 3 modes of backup encryption:. Backup encryption is a regulatory requirement for many customers. The presence of this capability in Oracle obviates the need to purchase it elsewhere. This mechanism also allows a physical standby database to be used as part of a clone, test, or development solution.

Note that while this database is open for reporting, it will not be able to receive any redo data from the primary database. Therefore, such a configuration may be more suitable for customers with less demanding disaster recovery requirements. With the control file enhancements, there is no longer a requirement to re-create the control file when changes in the configuration parameters are made.

This feature eliminates database downtime when a configuration parameter change is made in the control file. This feature enhances the ability to validate the block when it is in memory and not just on disk. For example, a backup job can be associated with its backup sets, and a backup set with its composite control file, archived logs, or datafiles. This features enhances the manageability of RMAN backups by providing a SQL interface to find additional statistics on the backup job and files.

This allows a DBA to startup in the same session. This feature enhances the tools used to debug space management-related problems to detect corrupt metadata. Distributed Transactions in a RAC environment detect failures and start the failover and failback processes automatically. The benefit of this feature is reduced administration and development time because Oracle manages the distributed transaction, therefore, there is no need to write manual procedures.

Accelerated instance startup makes Oracle Database available sooner when databases have multigigabyte shared memory configurations. Several additional views have been provided, and existing views have been enhanced to enable administrators to dynamically track the progress and performance of SQL Apply at a granular level. Enterprise Manager also provides historical trend analysis of the progress and performance data.

This feature makes it considerably easier to maintain and tune SQL Apply configurations and improves Data Guard manageability. It is now possible to flashback the primary and standby databases to an SCN or a point in time prior to the switchover operation. Using flashback in this way on a physical standby database preserves the standby role. This provides administrators more flexibility to detect and correct human error situations. This feature supports flexible data recovery that enables movement of the database back and forth in time even after you perform a resetlogs operation.

If you ever need to do a resetlogs operation for recovery purposes, you can take the database back to a point in time before the resetlogs if you find that you made a mistake. Oracle Database Backup and Recovery Basics for details. This incremental backup can be used to quickly move a standby database forward in time or load new data into a clone database for testing. This feature minimizes the time data is unprotected by creating an incremental backup that can be applied to a standby database to quickly make the standby database transactionally consistent with the primary database.

This also eliminates the need to continuously re-create a clone database with newer data values. It also clones statistics, checks and non-NULL constraints, and dependent objects on nested tables. This feature means less downtime as more tables are now supported for online redefinition. These enhancements are especially beneficial to customers using Oracle Applications. With this feature, system downtime is reduced and, during reorganization, storage requirements and rollback space requirements are significantly reduced.

Creation of a logical standby database no longer requires the creation of a specialized logical standby control file, which could not be used by RMAN. Logical standby databases can now be created easily from a physical standby database. This feature reduces specialized manual operations for creating a logical standby database and improves Data Guard manageability.

By optimizing database backups, only blocks currently used by the database are backed up. In previous releases, NULL compression was utilized, whereby only never-used blocks were excluded from backup. With this new feature, all unused blocks, whether they have been used or not in the past, will be excluded from backup. This enables faster backups and smaller backup files. This feature supports reorganization of additional database object types that are currently not supported for example, nested tables , enhances capabilities like launch-in-context, and improves usability of the Re-org wizard.

Currently if a tablespace contains objects like nested tables, the tablespace cannot be reorganized. This new feature enhances support for more object types for tablespace reorganization.

In addition, this feature provides enhanced support for launch-in-context so that applications such as Policy Violations can pass recommendations to the wizard directly and do not depend on the user to enter the data manually.

This feature provides the ability to associate a user-defined name, Restore Point, with a point-in-time. Restore Point can be specified such that it guarantees the database can be recovered to a particular point-in-time.

In addition, a special 'guaranteed' restore point ensures that the database can be flashed back to that particular point-in-time. Using guaranteed restore points can achieve efficient disk space usage, as only those flashback logs necessary to meet the guaranteed restore point are required to be retained.

Restore points can also be created as 'guaranteed', meaning it provides enhanced Flashback Database efficiency in recovery and disk storage requirements. And, it guarantees the database can be rewound to a specified point-in-time. Temporary datafiles that belong to locally managed temporary tablespaces are automatically re-created during recovery operation.

The following sections describe new features for Oracle Database 10 g Release 2 in the Business Intelligence area. In this release, Oracle extends the SQL language to support more powerful analytics. Bitmap indexes, a vital structure for efficient Business Intelligence query processing, also gain enhanced scalability.

This feature provides new behavior supporting upsert of cells. Oracle Database Data Warehousing Guide for details. The benefit of this feature is that MODEL clauses with certain types of rules perform better, handle larger model sizes, and include more powerful rule expressions. Native support of analytic functions is significantly faster than alternative techniques and simplifies expression of complex calculations, such as allocations and forecasts, in the MODEL clause.

Oracle is designed to meet all data requirements for the largest databases. VLDB environments, such as data warehouses, depend on partitioned tables. This release enables more:. The maximum number of partitions is now K-1, increased from a previous limit of 64K Increasing the maximum number of possible partitions to objects enables finer granularities for partitioned objects and even broader flexibility in choosing the right partitioning approach for a business scenario.

This feature enhances partition pruning for complex queries. Dropping large partitioned tables can affect tens of thousands of partitions that all have to be logically removed from the system. The capability of transparently dropping such an object in an incremental fashion optimizes the resource consumption and positively affects the run-time behavior.

A key requirement for business intelligence is to be able to analyze data more rapidly after an event occurs. Oracle provides a wide range of features to support efficient ETL extraction, transformation, load. This release reduces the information cycle time with enhancements ranging from data loading to query processing.

New features minimize rollbacks during bulk DML, enable more Change Data Capture environments, simplify materialized view refresh, and enhance query rewrite. The propagation between source and target database is a pure Streams implementation, enabling asynchronous CDC to leverage any existing Oracle9 i Release 2 system as a source. This feature combines the power and speed of bulk processing with the functionality of row level error handling. Oracle Database Concepts for details.

It can be combined with conventional fast refresh to enable a refresh, where one table is using PCT and the other table uses materialized view logs. This feature improves performance because materialized views can now be created in situations where they were previously not used due to the overhead of materialized view logs.

This feature also provides faster refresh due to the mix of PCT and conventional refresh. Query Rewrite may now use multiple materialized views. This feature improves performance as more queries are eligible for query rewrite and reduced maintenance costs because fewer materialized views are required. Levels in the dimension can now be skipped. For example, this feature allows a geography dimension where the state level might be skipped for cities such as Washington, DC.

The benefit is more complete modeling of the dimensions and performance benefits, because improved query optimizations are now possible. Optimized OLAP cube refresh supports applications demanding the very latest data.

Incremental aggregation of compressed cubes occurs automatically within the multidimensional engine. The multidimensional engine tracks detail level changes to the cube and aggregates only the summary level data that would be affected by the newly loaded data. This new feature improves performance for the process of aggregating an OLAP cube that has been stored using cube compression technology. This performance improvement is seen when the compressed cube has been incrementally updated with new data for example, when adding a new time period to the cube.

Semiadditive aggregations are those where the aggregation method on one or more dimensions is something other than sum. Examples include first, last, hierarchical sum, and hierachical weighted average. In Oracle Database 10 g Release 1, compressed cubes could not be used with semiadditive aggregation. Support for semiadditive aggregation methods with compressed cubes provides the opportunity for significant aggregation performance improvements.

Oracle Data Mining provides integrated mining capabilities directly in Oracle Database. Highlights include decision tree models, simplified model development, and a new SQL function for predictive data mining. This feature implements a state-of-the-art decision tree algorithm leveraging in-database parallelism. The benefit of this feature is a transparent, rule-producing algorithm.

The presentation of a decision tree in the form of human-interpretable rules increases the confidence, acceptance, and value of the algorithm. The decision tree is optimized to allow fast and scalable data scoring. The Predictive Analytics Package makes reasonable assumptions about the data and the mining process and greatly simplifies the use of data mining for end users.

This feature makes data mining more accessible to non-data analysts. Oracle Data Mining Concepts for details. This feature provides SQL built-in data mining scoring functions for classification, regression, clustering, and feature extraction data mining models. This unifies the overall product, enabling interoperability between models.

The following sections describe new features for Oracle Database 10 g Release 2 in the clustering area.

This release provides session management capabilities that improve the ability to balance workloads across instances in a clustered environment. Workload policies are defined which enable connection pools to route work requests to the appropriate instance based on real-time information. Real Application Clusters includes a Load Balancing Advisory that monitors the work for each service in an instance.

The advisory creates Fast Application Notification FAN events to provide feedback that enables routing by the connection pool to respond quickly to changing conditions in the system. In steady state, the system approaches equilibrium with optimal service times across all Oracle Database 10 g RAC instances. NET Connection Pools are integrated to provide the best connection to an application request instead of a random connection from the pool.

Runtime connection load balancing enables connection pools to route work requests to the connections that can best serve the work based on the FAN events received from RAC. Requests can be routed according to different policies. This allows for easy management of data that needs to be shared across nodes in a clustered environment. This release improves the RAC experience by verifying the environment before installation, providing tools to assist in diagnosing problems that may occur, and ensuring there are redundant copies of Clusterware Files.

Mechanisms are also provided for the online replacement of failed OCR devices. The benefit is that redundant copies of critical clusterware management files are automatically maintained to protect against single points of failure and eliminate the need for third-party storage redundancy solutions. Oracle Clusterware provides a Cluster Verification Utility that verifies the availability and integrity of a wide range of cluster elements in Oracle Clusters and Oracle Database 10 g RAC environments.

These facilities include both a standalone Cluster Verification Tool for use by DBAs and callable routines invoked automatically by Oracle installation, configuration, and system management tools.

The Cluster Verification Utility can be invoked at any stage of a cluster configuration. Cluster verification makes the installation, configuration, and overall management of Oracle Clusterware environments including Oracle Database 10 g RAC environments simpler by quickly and easily identifying problems in complex cluster systems.

In addition, diagnostic information for faster debugging and problem analysis is provided. The benefit of these enhancements is greater code reliability and faster problem resolution by Oracle Support Services and the development community. This release extends Oracle Clusterware by providing an open API which allows additional non-Oracle components running on the database server to be managed by Oracle Clusterware. An open API is provided to Oracle Clusterware to enable customers and partners to integrate their application system components into Oracle high availability environments.

Application system components registered with Oracle Clusterware are managed along with Oracle system components to ensure that failures of any component can be detected and recovery procedures initiated to quickly restore the overall system to an operational state. This feature ensures that complex cluster systems involving Oracle components and components from customers and partners can be managed together by Oracle Clusterware to provide high overall system availability.

Improvements for Text include a new set of document filters that provide better quality and performance, Asian language support for CTXRULE index type, and better manageability of text indexes. Also, the new KWIC feature also called snippet returns query keywords marked up in their surrounding text, allowing the user to evaluate them in context.

Oracle Text Application Developer's Guide for details. This new filter takes advantage of the automatic filtering technology licensed from Verity, Inc. Oracle Text's automatic filtering technology, licensed from Verity, Inc. This technology also enables you to convert documents to HTML for document presentation.

Oracle Text Reference for details. These new procedures enable you to see the keywords in their surrounding text, allowing you to evaluate them in context. With online indexing for local partitioned indexes, you can now create an index on a partition while updating it; the same as with unpartitioned indexes.

Also provided are:. Each returned document conforms to an XML schema that is registered with the database. Once this metadata has been extracted from the image, it can be stored in an Oracle Database, indexed, searched, and made available to applications using the standard mechanisms of Oracle Database.

This new inter Media capability allows Oracle Database 10 g Release 2 to serve as the repository for shared multiterabyte medical imaging archives used by HIMMS and PACS systems, life sciences and medical research centers, and government agencies. Oracle Multimedia User's Guide for details. In addition to the current support for format metadata height, width, mimetype, etc. Information supplied by digital cameras, image editing software programs, news and wire services, such as photographer, location, date, time, and other application data can now be extracted and represented as a collection of XML documents returned in XMLType.

Once metadata is extracted, it can be stored in an Oracle Database, indexed, searched and made available to applications using the standard mechanisms of Oracle Database. By placing the metadata and the image data in the same containing binary image, both types of data can be shared and exchanged reliably as a unit. Java Advanced Imaging 1. The following sections describe new features for Oracle Database 10 g Release 2 for the database in general.

Manual database upgrades are now easier to do. For any database version being upgraded to Oracle Database 10 g Release 2, only one common SQL script has to be invoked when performing a database upgrade.

Specifying a version-specific script is no longer required, because Oracle now automatically determines what version is being upgraded and runs the appropriate upgrade scripts for that database and all of its included components. Oracle Database Upgrade Guide for details.

The Pre-Upgrade Information Utility has been enhanced to provide improved resource estimations for tablespace space usage and elapsed upgrade runtime. This feature improves the manageability of Data Pump jobs and allows users to get accurate information about possible issues with their specific database upgrade prior to running DBUA or performing a manual upgrade.

This allows users to quickly start using Data Pump because a default directory object is automatically created. Data Pump Export dump files can contain database metadata objects in a compressed format, allowing dump files to consume less operating system disk space.

This metadata is automatically uncompressed during Import. In previous releases, the size of the file was unlimited. In previous releases, Enterprise Manager only monitored Data Pump jobs that had been created using Enterprise Manager.

However, it is a common activity for a DBA to create Data Pump jobs without using Enterprise Manager and it is possible for these jobs to take a very long time hours or days to complete.