• 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:
  • OAB Communications

    OAB - 11.5.10 FP K RUP 2 - I'm trying to send a communication, via email, to Participants who have a "gain a child" Life Event. I've Created a System Extract, which ran successfully. I created an RTF Template and merged the extract data into a PDF and ran the Extract Write XML concurrent process...

    Shigg11275 pointsBadges:
  • Problem to transfer Proc C to Oracle 10g

    Can you please tell me the procedure to run Proc C prpograms of Oracle 8i in Oracle 10g

    Idea5 pointsBadges:
  • Changing characterset in an existing Oracle Instance

    We currently have an instance in use that has the characterset of US7ASCII. The vendor of the application running on that instance has suggested we change to WE8MSWIN1252. do you think that any data could get corrupted when going from a 7-bit characterset to the 8-bit one and can we do this in...

    Manjit10 pointsBadges:
  • How to parse a string

    Hi, I have a file name that has multiple nodes, I want to get the file extension after the last '.'. How do I do this?

    CAGIRL5 pointsBadges:
  • report server error using oracle 10g

    Hi. I an using oracle 10g. when i run 10g reports individually it works fine but when i try it to connect with forms it gives error 'cannot connect toserver' please help how could i connect it to server.

    Raza15 pointsBadges:
  • How to submit a report request to be retrieaved at a later time.

    Hi everyone. Here is the problem we are having: Our report server is located behind a reverse proxy with a timeout setting of 10 minutes. However, the reports we are running take longer than that. Consequently the session times out and we lose the report. Is there a way to submit a report request...

    FelixF5 pointsBadges:
  • inserting

    from front end we will get 20 records at a time.how can we insert them into a table .

    Sarvasumanth5 pointsBadges:
  • How to parse a varchar2 column and insert date data into another column?

    I'm working on a database that has an important date stored in a notes column that is varchar2. The date is always in the same position in the column. Does anyone know a function or a way I could pick the date out of this column and use it to update a date in another date column? Thanks for your...

    Szdb25 pointsBadges:
  • performance and tuning examination guides

    What would you recommend as good study guides for performance and tuning 9i exam

    Cece5 pointsBadges:
  • Binary Double / Binary Float and SQL*Loader

    Does SQL*loader support database columns Of Binary Double/Float when applying Direct Path?

    Hillel20085 pointsBadges:
  • Oracle Lock Query

    Is it possible to determine who is locking (not blocking) a row in an Oracle database? This relates to a problem I have with a COBOL program that needs to determine who is locking a requested record. I can determine the rowid of the requested record (after Oracle has informed the program that the...

    RichardReynolds5 pointsBadges:
  • How to begin tracing a connection Oracle 10.2.0.3 server running on Solaris 10

    Developers are telling me a page loads more slowly on one server than another for the same query that is run. how can I trace this connection to find out what it is doing on both servers?

    Szdb25 pointsBadges:
  • Error calling APPS.AR_ADJUST_PUB.Create_Adjustment

    Calling this API from SQL Navigator and working on a Release 12 implementation. This is the error message: ORG ID is required. I'm setting all this in the begining, but still I get the message. apps.fnd_global.apps_initialize(1154, 20678, 222); APPS.ARP_GLOBAL.INIT_GLOBAL; FND_MSG_PUB.Initialize;...

    Mirandai5 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