• Oracle Reports6 Live Previewer

    Hi I am using Oracle reports 6 to modify some reports first developed in an earlier version. My problem is that I do not get the editing toolbar showing when I run the report in Live Previewer. Is there some setting somewhere? However, If I develop a new report then the live previewer and all...

    Grayadlam5 pointsBadges:
  • How Do I release unused space from a tablespace after dropping a blob table

    I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this...

    Hmhora10 pointsBadges:
  • ORA-03113: end-of-file on communication channel

    I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running...

    OracleATE190 pointsBadges:
  • Does Oracle Stream data replication requires identical tables structure between source and Target Databases?

    We are considering the use of Oracle Data Stream to replicate data from operations database to a separate Helpdesk database. Our users require near real-time data loaded in the helpdesk database. What are the constraints imposed by Oracle streams for table design? Does it require for tables...

    Ss20095 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

    Inprise610 pointsBadges:
  • Errors in Creating Oracle packages

    Can anybody plz find out the error in the following code?? plz reply back. SQL> CREATE OR REPLACE package body PKG_IMAGEM1 2 as 3 PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, 4 P_College IN VARCHAR2, 5 P_CourseCat in varchar2, 6 P_CourseName in varchar2, 7 P_StudentName in varchar2, 8 P_ID in...

    Shreeshonkar10 pointsBadges:
  • PL/SQL error

    Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

    Inprise610 pointsBadges:
  • Reports go blank with Oracle 10g using JReport (work perfect with Oracle 9i)

    HI, I have upgrade oracle database from 9i to 10g via export/import, My application is using Jreport. When I was using oracle 9i Reports were working perfect but after upgrading to 10g when I fetch reports it goes blank.

    Hasan15 pointsBadges:
  • Calculate SIze of Oracle Table with BLOB column and BLOB Index

    I have a 30 GB table with BLOB column and BLOB INDEX. However, when I used Toad to look at the BLOB INDEX, it is a system generated and have NO COLUMN. Question 1: How do I calculate the actual size of thhe BLOB table, BLOB index, etc ... Question 2: How do I determine if this BLOB table and BLOB...

    Hmhora10 pointsBadges:
  • error in connection between oracle8i&developer2000

    I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...

    POWERINIT0 pointsBadges:
  • Is my Oracle certification current enough?

    I did my Oracle certification in developer track in April, 2001 (Oracle 8 with developer 6i). Is that certification still applicable or would I have to update? If updation required which online papers I would have to undertake.

    111710 pointsBadges:
  • CPU UTILIZATION IS SHOWING 0 IN SAR REPORT

    Hi all I am facing problem on oracle 10g We have oracle 10g on solaries 5.9 We have database in RAC envinment with 2 nodes We have 10g AS as a front end application. My problem is when user fired user name and passwd the application page are coming very slow it is taking very much time mean while...

    Oracle dba115 pointsBadges:
  • Need help creating a specific Oracle View

    We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would...

    OracleATE190 pointsBadges:
  • IMP-00069 error on Oracle 8i dump import

    Oracle 8i is loaded on two machines located at different places. If .dmp file taken from one machine is importing to another one, it gives the error imp-00069. I checked NCHAR charecterset with command "select * from nls_database_parameters;" on both machine and all 18 parameters are same on both....

    OracleATE190 pointsBadges:
  • Oracle: How to import schema to replace identical schema but retain unique identifier?

    I have spatial (SDO) data that I would like to import from one schema into another identical schema. My problem is that I only want to replace the spatial data that have the exact same UID_1 (Unique Identifier). Is there a way to do this and if so how?

    OracleATE190 pointsBadges:
  • Oracle archives are not moving from primary to standby database

    Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?

    OracleATE190 pointsBadges:
  • ADO connection fails after upgrading from Oracle 10g to Oracle 11g

    I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

    OracleATE190 pointsBadges:
  • oracle cold backup 8.1.7.4 restore to oracle8.1.7.4 Can it be done.

    Please advise if I can take a cold backup from oracle 8.1.7.2 and restore onto oracle 8.1.7.4 binaries thanks

    Dannyl0 pointsBadges:
  • Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)

    CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record (...

    APB10 pointsBadges:
  • Problem running Oracle Forms 9i

    how to run my oracle9i form it is asking jinitiator but when i say to download it is not working

    Ahmed105 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