• Login
  • Become a member
  • RSS
  • Part of the TechTarget network
SearchOracle.com
  • News
    • Latest Headlines
      • Privileged user management a must for DBAs
      • Subtle, meaningful differences in right-time and real-time analytics
      • Oracle competition is worth a look, Collaborate attendees say
      • 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
      • Domain-specific Oracle master data management
      • The basics of Oracle database availability
      • Oracle application performance management done right
      • 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

  • Use Log Miner to verify filtered Oracle NULL columns

    Learn how to use Log Miner to verify filtered Oracle NULL columns in an INSERT statement from a redo log write in this tip from Oracle database expert Brian Peasland.

  • When to use double quotes in Oracle column

    Are you seeing an invalid identifier? Learn when to use double quotes in Oracle column names to avoid this in this tip from PL/SQL expert Dan Clamage.

  • How to avoid duplicates of Oracle delimited codes

    Learn how to avoid duplicates of Oracle delimited codes in a CLOB column by scanning the column in this tip from Oracle PL/SQL expert Dan Clamage.

  • How to copy data from Table1 to Table2

    Oracle PL/SQL expert Dan Clamage explains two methods for copying table data from table1 to table2 when the tables have different primary keys in this expert tip.

  • How to use iterative scans to create hierarchical queries in SQL

    PL/SQL expert Dan Clamage explains how to use iterative scans to create hierarchical queries in SQL that are database agnostic.

  • How to list rows with special characters in PL/SQL

    Want to learn how to list rows with special characters in PL/SQL? Read this tip from our PL/SQL expert for advice on how to write a PL/SQL query using the translate, char or trunk functions.

  • How to use a stored procedure to fetch from ref cursor

    Oracle expert Dan Clamage explains how to use a stored procedure to fetch from a ref cursor in Oracle in this tip.

  • Why can't I install Oracle 9i on Windows 2003?

    Having trouble installing Oracle 9i on Windows 2003? Learn why in this tip from Oracle expert Brian Peasland.

  • How to use SQL Plus to export Oracle data from more than one table

    Learn how to use SQL Plus to export Oracle data from more than one table with the SPOOL command in this tip from Oracle expert Brian Peasland.

  • How to perform a Big to Little Endian conversion in Oracle 8i

    Learn how to perform a Big to Little Endian conversion in Oracle 8i using either an Oracle upgrade or export/import in this tip from Oracle expert Brian Peasland.

  • How to perform database recovery with a corrupt control file in Oracle

    Learn how to perform database recovery with a corrupt control file in Oracle with these step by step instructions, including how to use the CREATE CONTROLFILE command, from Oracle expert Brian Peas...

  • How to enable remote Oracle OS authentication with OS_AUTHENT_PREFIX

    Oracle expert Brian Fedorko explains how to enable remote Oracle OS authentication in Windows and Linux, including why you might receive the ORA-010145 error when trying to have an Oracle user iden...

  • Why do I get an Oracle not available error with Oracle 8i on Windows?

    Are you getting an Oracle not available error when trying to use Oracle 8i on Windows 2003? Learn why in this tip from expert Brian Peasland.

  • Why am I receiving Oracle memory allocation errors?

    Are you receiving Oracle memory allocation errors? Learn why you may be having memory allocation problems in Oracle in this tip from Oracle expert Brian Peasland.

  • Can I check an Oracle instance without logging into the Oracle server?

    Can you check an Oracle instance to see if it's running without logging into the Oracle server? Learn how to do so in Windows or Linux from expert Brian Peasland.

  • How to execute DML in an Oracle trigger with EXECUTE IMMEDIATE

    Read how to execute DML in an Oracle trigger with the EXECUTE IMMEDIATE statement in this tip from Oracle expert Brian Peasland

  • Can I perform an Oracle server backup through a client machine?

    Learn how to perform an Oracle server backup through a client machine with Oracle's RMAN utility in this tip from Oracle expert Brian Peasland.

  • How does the Oracle LGWR write to online redo log files?

    Learn how the Oracle LGWR writes both uncommitted and committed transactions from the log buffer to the online redo log files in this tip from Oracle expert Brian Peasland.

  • How to join two tables with unique keys in Oracle

    Learn how to use an Oracle table join to connect two tables with unique keys in Oracle in this tip from Oracle expert Brian Peasland.

  • How to restore a dump file with the Oracle SHOW=Y option

    Oracle expert Brian Peasland explains how to restore a dump file with the Oracle SHOW=Y option before precreating tablespaces.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
More from Related TechTarget Sites
  • Data Management
  • Business Analytics
  • SAP
  • SQL Server
  • Java
  • Data Center
  • Content Management
  • Financial Applications
  • Data Management
    • New BI stack tackles data load at Boston Children's Hospital

      Boston Children's Hospital upgraded its business intelligence architecture to boost enterprise reporting, a move that also required retraining users.

    • Expanded Hadoop use cases will drive need for new enterprise features

      With user interest rising, Hadoop vendors are trying to pave a path to higher adoption with add-ons that target issues holding the technology back.

    • Jim Goodnight on SAS in-memory analytics and the data scientist

      A podcast Q&A with SAS execs Jim Goodnight and Jim Davis looks at big data enablers, including in-memory analytics, and the role of data scientists.

  • Business Analytics
    • Marketing and advertising remain sweet spots for big data technology

      Marketing and advertising are the sweet spots for big data, but those who serve up marketing insights and ad space will need to evolve to survive.

    • Strategies for de-cluttering business intelligence dashboard designs

      Expert Brian Jordan shows business intelligence managers how to avoid developing dashboards that overwhelm business users with too much information.

    • Making mobile BI applications a reality: Key steps to take

      In a podcast, BI expert William McKnight discusses best practices and action items for managing deployments of mobile business intelligence tools.

  • SAP
    • Analyst Jon Reed on SAP SapphireNow 2013, SAP Fiori

      Analyst Jon Reed gives his take on SAP Fiori, a collection of apps intended to cover a wide range of business processes as simply and efficiently as possible.

    • Ariba Network announces QuickBooks integration

      At its annual conference, Ariba announced a new tool by partner Dell Boomi that lets small businesses integrate their QuickBooks accounting with the Ariba Network.

    • Software license audits come in different forms, expert says

      Your next software license audit may be an inventory optimization exercise in disguise. Either way, the trick is to be prepared, writes one analyst.

  • SQL Server
    • Database index design and optimization: Some guidelines

      What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.

    • Adam Machanic talks SQL Saturday

      We caught up with Adam Machanic, group leader of the New England SQL Server user group, at SQL Saturday Boston. Find out what he shared with us.

    • SQL Server meets database application security

      Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.

  • Java
    • Inside advice on the use of Platform as a Service in the enterprise

      CloudBees founder and CEO Sacha Labourey answers tough questions and hands out practical advice about PaaS and how it works in the enterprise.

    • How skilled portlet developers make the portal strategy work

      Portals are providing more value than ever, and having skilled portlet developers on staff brings the technology to new levels.

    • Five portlet development tips software engineers can't ignore

      Here are five quick portlet development tips that software engineers will find helpful as they develop applications for the portal.

  • Data Center
    • Data center technologies evolve to meet tomorrow's computing demands

      VMware's upcoming public cloud and AMD's 64-bit ARM servers are technologies for the data center that exemplify the changes in the IT industry.

    • New data center cooling strategies to improve efficiency, lower costs

      Stagnant strategies for data center cooling will keep energy bills climbing ever higher, but a more modern approach can bring them back down to earth.

    • Converged systems usher in data center transformation

      The rise of converged systems has brought a new level of manageability to the data center, but these integrated offerings have a few drawbacks.

  • Content Management
    • Get 'em ready: Tips for planning a SharePoint 2013 training program

      SharePoint is a complex application. But training business users for an upgrade to SharePoint 2013 doesn't have to be a daunting task for IT teams.

    • The organization of the future: Not just hybrid IT, but hybrid people

      The adoption of hybrid IT approaches creates a need for executives who can both formulate business objectives and assess IT requirements.

    • SharePoint technology feels growing pains as 2013 release arrives

      SharePoint 2013 adds new features to the collaboration software. But it comes at a time when SharePoint's value is being questioned in some quarters.

  • Financial Applications
    • With HANA mobile apps, SAP is erasing business models -- including its own

      At Sapphire Now 2013, in-memory analytics and mobile app demos showed how companies can turn big data into profitable service lines.

    • IaaS business scales faster with Zuora billing software

      While a user testified to the benefits of Zuora specialty billing software, an expert said the niche tool is not necessary for all.

    • Analytics, global HR hot topics at Bersin conference

      In this podcast, associate site and news editor Emma Snider recaps some of the key takeaways from Bersin by Deloitte's Impact 2013.

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