• 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
      • E-book: Ensuring data quality throughout your Oracle environment
      • Managing batch jobs in Oracle application environments
      • How to evaluate data warehouse appliances
      • 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

  • Return non-matching rows from both tables

    An Oracle user asks how to return only non-matching rows when joining two tables.

  • Can I write triggers from Oracle 7 to Oracle 11?

    An Oracle user asks how to write triggers from Oracle 7 to Oracle 11.

  • I am running out of disk space, how do I hot swap my drives out?

    An Oracle user asks, "I am running out of disc space, how do I hot swap my drives out?"

  • Taking a full offline backup

    A SearchOracle.com member asks how to take a full offline backup through Oracle 8.0.

  • Using rule-based optimization to optimize a query

    A SearchOracle.com member asks, "Can I have a detailed explanation of how and when the 15 rules of Rule Based Optimization are used when optimizing a query?"

  • Clone database vs. standby database

    A SearchOracle.com member asks, "Can you tell me the difference between clone database and standby database? "

  • Cleaning a temporary tablespace

    A SearchOracle.com member asks, "I have an Oracle 10g database with its temporary tablespace full. Is there any way to clean this tablespace?"

  • How to convert a SQL Server 2005 database to Oracle 10g

    Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?"

  • Using Oracle Streams

    Oracle expert Harish Harbham explains how Oracle Streams can be used for replication.

  • Becoming a Junior DBA

    A SearchOracle.com member asks, "What are the requirements for becoming a Junior DBA?"

  • When trying to find a job, should I focus on becoming educated in Oracle or SQL?

    A SearchOracle.com member who wants to restart his career asks, "Should I focus on Oracle or SQL? What, in your opinion, is there a greater demand for in the workplace?"

  • How important is ERP knowledge?

    Oracle expert Michael Hillenbrand explains how important ERP expertise is when starting a career in Oracle.

  • Value of Oracle Certified Professional (OCP) exam in landing entry-level job

    A SearchOracle.com member asks, "Will taking the OCP Exams be beneficial to me in getting a DBA or Database Designer job?"

  • How to transfer data from Oracle to MS SQL Server

    SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server.

  • How to create a mediated schema

    A SearchOracle.com member asks, "I have two different relational schemas with me. Can I get an example as to how to integrate them and create a mediated schema?"

  • How to use Oracle Heterogeneous Services

    Expert Harish Harbham explains how to use Heterogeneous Services to update non-Oracle systems.

  • Extracting data from within a column

    A SearchOracle.com member asks, "How do you write a command that will return data within a column? "

  • How to use DISTINCT on just one column

    SQL expert Rudy Limeback explains how to use DISTINCT on just one column.

  • How to update columns dynamically

    A SearchOracle.com member asks, "How do you update columns dynamically, depending on the conditions?"

  • Oracle 10g and Vista Premium OS

    A SearchOracle.com reader asks, "Is Oracle 10g compatible with the Vista Premium OS?"

  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
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
    • 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.

    • Sentiment analysis just part of the SAP social media vision

      Social media in the enterprise is in constant flux. One of SAP's top social media chiefs lays it out, from sentiment analysis to social collaboration.

  • SQL Server
    • 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.

    • xVelocity Columnstore Indexes in SQL Server 2012

      Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.

  • Java
    • JSR-286 development tutorial: Mastering request-response programming

      This portlet programming tutorial shows how the PortletRequest and Portlet Response are used when developing JSR-286, request-response based apps.

    • JSR-286 development tutorial: An introduction to portlet programming

      This portlet programming tutorial is an introduction to developing JSR-286 applications that can be deployed to any standards-based portal server.

    • Mastering Tomcat: Installation, configuration, logging and optimization

      To master the Apache Tomcat server, administrators and developers need to be familiar with installation, configuration, logging and performance optimization

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

    • Offboarding automation reduces risk, manual labor

      With HR's focus on onboarding, the offboarding process often gets short shrift. But making do with checklists and spreadsheets can lead to problems.

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