• Most common oracle DBA tool.

    which tool is most common for database(oracle) administration , instead of OEM?

    Aqmemondba80 pointsBadges:
  • When do I use a collection instead of a table

    I am an old MS SQL server guy and I am doing some work in oracle 10G. Most of what I am doing is all set manipulation(insection between two dataset) My first instinct would be to use temporary tables and use a not exists. I was wondering if that is the most efficient way in oracle. I read about...

    Kmaccrimmon5 pointsBadges:
  • Oracle D2K report printing extra space at ery page problem

    Hi, when I m trying to take print out of oracle reports, print is coming fine but it leaves space at starting of evry page,like that space gets increses at evry page. OS is winXP..do i need to config in .PRT .. im using printer winproLQ1050+. plz help me out. Shailesh

    Shaileshb10 pointsBadges:
  • Data Scrub in Oracle 10g

    I am looking for algorithm for Data Scrub in Oracle 10g - I work with sensitive data and I need to get some help as to how to go about this and if any body can come up with some codes, I really appreciate that. There are some ready made softwares available, but I am interested in getting to know...

    Jug5 pointsBadges:
  • Is there a config file to set sqlplus default to GMT?

    Need help please. I need to set sqlplus to default to GMT instead of local timezone. Is there a way to do this? TIA, slee72890

    Slee728905 pointsBadges:
  • Commit during loader replace ?

    Hi. I would like to know if sql*loader commits after it deletes the rows when executing loader option replace. Is it possible to make it commit only after everything is done, so that there is no second when the table is empty. Thanks for your help.

    Cgfchat5 pointsBadges:
  • Hyperion Workspace Error

    There is communication error while loading tree data. While accessing the Hyperion Planning 9.3.1 through Hyperion Workspace deployed on weblogic 9.1 server.

    Rajpurav5 pointsBadges:
  • Error(55,8): PLS-00103: Encountered the symbol “C1″ when expecting one of the following: := . ( @ % ;

    Hi All, I get the following error on compiling my stored procedure code - ****************************************************************************** Error(55,8): PLS-00103: Encountered the symbol "C1" when expecting one of the following: := . ( @ % ;...

    Ravipatil200815 pointsBadges:
  • Error accessing Oracle data using SQL job

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 pointsBadges:
  • Community Update: New Member Contest Win a XBox 360 this month for your participation.

    After a long, stressful day in IT, video games can be a great way to unwind and relax. That’s right, you know where this is leading. It’s time for a cool new contest on IT Knowledge Exchange. The month of September ( Sept 1-Sept 30) is your chance to get your hot little hands on your very own...

    ITKE345,065 pointsBadges:
  • Oracle Project Costing – GL date error

    In the process 'Transfer labor cost to GL', got error-msg - "could not create valid GL date"; however GL period is OPEN in GL module and also in the Projects module.

    PMkj5 pointsBadges:
  • How to display reports in a web page using information from Oracle

    I am wanting to create a web page that can pull information from Oracle and display the information in an organized manner. I would like to have pull down menus for certain columns so that it is easy to sort data without seeing all of the information at once. What would be the best way to do this?...

    Cyansky50 pointsBadges:
  • Oracle 9i Support

    Hi, Can anybody please let me know that how long Oracle Corporation will support Oracle 9i database? Regards, Satyajit

    Choton5 pointsBadges:
  • Oracle ignores hints

    Oracle 10g does full table scan when he should use index specified in HINT

    Sueterrin5 pointsBadges:
  • Question on Oracle Forms 10g

    Hi I have a requirement of reading a document sitting on a client machine on the network and printing the same from a Oracle Forms screen. The document is not necessariy on the OS of the machine from which I access the form, it is most times on other machines on the same network. The input I intend...

    VIKR5 pointsBadges:
  • dbconsole configuration

    is my RAC database will go in quesced state if i configure dbconsole.

    Charminar5 pointsBadges:
  • Oracle Data types

    I am just learning an ORACLE 9i Book and i was seen that in number Data type the Range is Lies between 1 to 38 in Decimal And -84 to 127 of Scale Range How it is possible because these Fraction degits are subtratect from whole degits ex:- var1 number (5,25);--------------(1)--it is possible? var2...

    Tejas5 pointsBadges:
  • Duplicate Sql

    Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

    Garimella5 pointsBadges:
  • New way of handling RAID 5?

    As an Oracle DBA, I have heard and read a lot about RAID 5 and what it can do to database write performance. Now I understand RAID 5 has been improved to the point that all of the things that caused the overhead are now being handled in disk cache, and write times are now close to that of RAID 0+1....

    Mljsher0 pointsBadges:
  • RAID configuration for Oracle database

    Presently we have a 9iOracle database sized at approximately 50MEG on an HP-UX 11.11 server on a SAN. Our software app vendor is telling us that we should have the database on RAID 10 for better performance. They have done benchmarking with DB sized at what ours will be in the future. (Multi...

    Roadkill0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following