• Login
  • Become a member
  • RSS
  • Part of the TechTarget network
SearchOracle.com
  • News
    • Latest Headlines
      • Sales reps out of control on issue of software license compliance
      • Oracle to rebrand Fusion Apps as Oracle Cloud Services, analyst charges
      • Aon eSolutions picks Oracle Database Appliance for overseas expansion
      • View All News
    • Featured
      • Business Applications Digest

        Essential resources for business and IT professionals tasked with designing an effective enterprise-wide business applications strategy – covering issues on cloud vs. on-premises apps, purchasing tips, implementation and upgrade best practices and...

        Download Now!
  • Premium
    Editorial
    • E-Books
      • Must-know BI and reporting trends for Oracle eBusiness Suite adopters
      • E-book: Ensuring data quality throughout your Oracle environment
      • Managing batch jobs in Oracle application environments
      • View All E-Books
    • E-Zines
      • Business Information
      • BI Trends + Strategies
      • View All E-Zines
    • E-Handbooks
      • Oracle analytics: Real time isn’t for everyone
      • Giving your Oracle hardware performance a shot in the arm
      • View All E-Handbooks
    • Research
      • Wayne Eckerson explores the market for in-memory visualization tools
  • Oracle
    Topics
    • Topics
      • Database Admin

        Oracle DBA tools, Backup and recovery, Database design, Export, import and migration, Installation, upgrades and patches, Error messages, Oracle performance problems and tuning, Oracle security, Availability, Real Application Clusters (RAC), Cloud infrastructure, MySQL database

        Development

        BPEL in Oracle, SQL, PL/SQL, Stored procedures, Java / J2EE, XML, Open Source

        Applications

        Enterprise and business performance management, E-Business Suite, Implementing and upgrading Oracle apps, Fusion applications, JD Edwards (JDE), PeopleSoft, Hyperion, Siebel and Oracle CRM

      • Oracle management

        Oracle Web 2.0, Oracle strategy and product roadmap, Oracle support services, Oracle vs. SAP, Regulatory compliance, Market analysis, Oracle acquisitions, Oracle on demand and SaaS, Outsourcing, Business process management, Small businesses, DBA jobs training and certification

        Fusion

        Oracle and BEA, Application Server, SOA (service-oriented architecture), Data and application integration

        Data Mgmt

        BI (business intelligence), Metadata, Data quality, Data warehousing

      • Infrastructure

        Cloud computing infrastructure, Exadata and Exalogic, Virtual machine, Operating system, Oracle hardware decisions, Oracle on Linux, Grid computing

    • Hot Topics
      • Installation, upgrades and patches
      • Fusion applications
      • Oracle support services
  • Tutorials
    • Advice & Tutorials
      • Oracle database performance tuning guide
      • Oracle applications learning guide
      • Third-party tools for Oracle: Special report
      • Oracle upgrades: Tips and trends
      • Oracle virtualization introduction guide
      • Oracle grid computing and cloud computing: Special report
    • Technology Dictionary
      • Find definitions and links to technical resources
      • Powered by WhatIs.com
  • Expert
    Advice
    • Tips
      • Unlock the potential of the Oracle Exadata architecture
      • Improve database performance with Oracle segment space management
      • Six tips for maximizing your PeopleSoft upgrade or other applications
      • View All Tips
    • Answers
      • Perfect the Oracle RMAN duplicate 10g command
      • Doing SQL arithmetic with SELECT instead of arithmetic operations
      • Managing SQL parent table-child table relations
      • View All Answers
    • Ask a Question
      • Pose a question to the SearchOracle.com Experts
      • Get help from our technical community
      • Powered By ITKnowledgeExchange.com
  • White
    Papers
    • Research Library
      • White Papers
      • Business Webcasts
      • Downloads
      • Powered by Bitpipe.com
    • Product Demos
      • Try out software demos
      • Powered By 2020Software.com
    • Resource Centers
      • View All Resource Centers
  • Blogs
    • Blogs
      • Eye on Oracle
      • Powered By ITKnowledgeExchange.com
  • Home
  • Ask the Experts
  • Perfect the Oracle RMAN duplicate 10g command

    One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.

  • Do SQL arithmetic without using arithmetic operations

    Learn how to do simple SQL arithmetic operations without using the arithmetic operators.

  • Managing SQL parent table-child table relations

    Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.

  • Meet All Experts

Submit a question to our experts

Expert Answers

  • Backup and recoveries of Oracle RAC 10gR2

    An Oracle user asks expert Brian Peasland a few questions about taking a backup and recovery for RAC 10gR2.

  • How to recover a control file

    An Oracle user asks how to recover their control file in the case of media failure.

  • The USING BACKUP CONTROLFILE clause in Oracle commands

    An Oracle user asks how a command with the USING BACKUP CONTROLFILE clause works.

  • How to use the OPatch Utility in Oracle

    Expert Brian Peasland explains how to use the OPatch Utility to find the CPU patch level applied to the particular database.

  • Normalizing a crosstab table

    SQL expert Rudy Limeback explains how to use a UNION query to normalize a crosstab table.

  • SQL for hourly totals for the last 48 hours

    SQL expert Rudy Limeback explains to an Oracle user how to user asks how to generate datetimes or use left outer join to get hourly totals for the last 48 hours in SQL.

  • LEFT OUTER JOIN to a MIN/MAX row

    An Oracle user asks SQL expert Rudy Limeback how to use a LEFT OUTER JOIN with a MIN/MAX condition.

  • How to implement a ref cursor called in a stored procedure

    Expert Brian Peasland explains how and when to implement a ref cursor called in a stored procedure.

  • Export dump with files larger than 2 GB

    An Oracle user asks how to create an export dump with files larger than 2 GB.

  • How can I solve the ORA-4030 error?

    An Oracle user asks how to solve the ORA-4030 error: out of process memory .

  • What is Unix shell scripting?

    Oracle expert Brian Peasland explains about Unix shell scripting.

  • How to get history of modified data from Oracle databases

    An Oracle user asks how to get the history of data modified from an Oracle database.

  • Performing a backup with table locks

    An Oracle user asks if a backup can be performed when there are table locks on certain fields.

  • How to move data faster with a database link

    Oracle expert Brian Peasland explains how to move data across a database link to speed up an import.

  • Why am I getting the ORA-00381 error when initializing the parameter?

    An Oracle user asks why they are getting the ORA-00381 error when initializing the parameter.

  • Performance issues in Oracle 9i

    An Oracle user asks if upgrading their database to 10g will help solve performance and space management issues in Oracle 9i.

  • What is the difference between an instance and mounting in Oracle?

    An Oracle user asks what the difference is between an instance and mounting.

  • Benefits of a 3NF level of normalization

    An Oracle user asks expert Brian Peasland his general opinion regarding normalizing data in an Oracle database.

  • Moving a table with a LOB column

    An Oracle user asks if anything different has to be done when moving a table with a LOB column.

  • In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?

    An Oracle user asks if the number of columns in a table affect the performance during SELECT/INSERT/UPDATE.

  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
More from Related TechTarget Sites
  • Data Management
  • Business Analytics
  • SAP
  • SQL Server
  • Java
  • Data Center
  • Content Management
  • Financial Applications
  • Data Management
    • From 4GLs to HTML5 desktop apps: Bringing data to the masses

      Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.

    • Enterprise data quality efforts in good company with MDM, governance

      Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.

    • Better data quality process begins with business processes, not tools

      Efforts to improve data quality should start with procedural changes to help avoid data errors, then the possible addition of data quality software.

  • Business Analytics
    • Member Exclusive Downloads

      Member Exclusive Downloads from SearchBusinessAnalytics

    • In-memory applications take on big data analytics challenge

      In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.

    • Texas utility deploys operational intelligence, improves 'on-boarding'

      TXU Energy applied Vitria operational intelligence software to gain a better customer view. Careful processes selection ensured quick performance.

  • SAP
    • Food bank network delivers with SAP mobility

      The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.

    • SAP adds hybris to its SAP CRM tool set: More choices, or confusion?

      One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.

    • Limit returns, SAP procurement expenses with a stability study

      Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.

  • SQL Server
    • SQL Server 2014 'keeps up with the Joneses,' says analyst

      Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.

    • SQL Server high availability: Natural enemy of virtualization?

      Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.

    • SQL Server 2014 due out in late 2013, in-memory OLTP a big feature

      Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.

  • Java
    • Will the Red Hat model work for IaaS cloud computing with OpenStack?

      The Red Hat transition is to move their successful model to IaaS through OpenStack and cloud computing. But will this new move from the JBoss company work as well as RHEL did a decade ago?

    • How Red Hat's Linux and OpenStack IaaS drives Intel's bottom line

      While a major protectorate of intellectual property, Red Hat Linux and OpenStack IaaS offerings provide the bonus of driving innovation, which leads to more chips being purchased, driving revenue at Intel's bottom line.

    • Embracing OpenStack: How Red Hat commoditized open source cloud computing

      By leveraging OpenStack, Red Hat plans to commoditized cloud computing, just like they commoditized open source Linux ten years ago.

  • Data Center
    • Red Hat Open Hybrid Cloud aids private, public cloud management

      Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.

    • Mainframe modernization takes on urgency

      A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.

    • AMD microprocessors regroup to fight another day

      Intel may win the server war, but AMD microprocessors could find more acceptance in another niche market.

  • Content Management
    • Cloud collaboration software connects at networking company Enterasys

      Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.

    • Data value chain puts the focus on what matters most to a business

      In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.

    • Quiz: Implementing digital asset management systems

      Take this quiz to test your knowledge of digital asset management (DAM) technologies and processes.

  • Financial Applications
    • CFOs reap the benefits of BPM tools in efficiency, compliance

      BPM tools can help CFOs reduce errors and enhance the accuracy of reporting and forecasting, experts say.

    • CFOs can seize opportunity to lead good governance over IT

      Get tips from experts on how to enact good IT governance by getting the right people to do the right processes.

    • CFO survey finds interest in analytics and cloud on the rise

      According to a recent survey, CFOs expect to invest more in cloud, mobile and big data technology in coming years and spend less on IT infrastructure.

All Rights Reserved,Copyright 2003 - 2013, TechTarget
  • About Us
  • Contact Us
  • Site Index
  • Privacy policy
  • Advertisers
  • Business partners
  • Events
  • Media kit
  • TechTarget Corporate site
  • Reprints
  • Archive
  • Site map