• 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:
  • Oracle Applications view functions mapping

    hi, I have a query regarding Oracle Applications (OA) and I hope you will be able to assist me. I am looking for a list of OA functions which are VIEW functions, according to the hard-coded definition of Oracle. In other words, I am looking for a list of FORM FUNCTIONS that allow users only to view...

    Orit15 pointsBadges:
  • Oracle to SQL Server Migration – User Defined data types

    Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

    Kumar937825 pointsBadges:
  • Using the BLOB datatype

    IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.

    Rupchandani5 pointsBadges:
  • Insert Speed

    I want to insert 2MB of data into an oracle database in 1 second. Is it possible?. How much data can be inserted/sec ?

    Gopas5 pointsBadges:
  • Oracle to SQL Server Migration – CURSOR type conversion

    When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

    Kumar937825 pointsBadges:
  • rac scalability for batch, oltp, dss

    Hi all, Please advise how each of the following applications BATCH, ONLINE, DATAWAREHOUSING would scale up or speed up in oracle rac? that's how each will benfit changing from single instance to RAC ? thanks andrew

    Vletter15 pointsBadges:
  • Oracle Batch report and Phase 6360 printer

    I am facing the printing problem when i send batch printing through giving printer name and pdf format and batch syn. parameter to report server which create on machine. When these reports forward to xerox phaser 6360 printer then some the printer stop after printing one report and some time our...

    Rao1234565 pointsBadges:
  • different ways to load data files in oracle database tables

    other than SQL Loader

    Sman5 pointsBadges:
  • SQL Integration with Oracle10g

    have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) as...

    Kmadani35 pointsBadges:
  • What’s the best way to import an Oracle database?

    I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each...

    OracleATE190 pointsBadges:
  • ORA-01925: maximum of 145 enabled roles exceeded

    I’m getting ORA-01925: maximum of 145 enabled roles exceeded and I can't change the max_enabled_role. I dropped some roles but still face the same issue. Not able to login as system. Please suggest. Thanks.

    OracleATE190 pointsBadges:
  • Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i

    Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.

    Vini Chandamama100 pointsBadges:
  • export data based on date

    Hi i'm new to oracle how can i use the export command to export data based on date and subsequenly purge the data exported from the database? Thanks for any info

    fartman50 pointsBadges:
  • autobackup

    How do you enable the autobackup for the controlfile using RMAN

    Narmada5 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