• Oracle XE 18C Installation

    Please share the download link for oracle 18c xe on ubuntu and share installation instructions. Is it free or paid?

    Giri51215 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE1,119,190 pointsBadges:
  • problem configuring System DSN (via ODBC) using the driver IBM Integration Bus

    Hello, I started using IBM Integration Bus 10.0.0.15 Developer Edition. I am now having problems with the ODBC oracle data sources and drivers. when I create a System DSN (via ODBC Data source System administrator) using the driver IBM Integration Bus 10.0.0.15 Developer Edition - Data Direct...

    Ekrusha5 pointsBadges:
  • INCREASE ORACLE 9i MEMORY

    How to increase oracle 9i memory manually My Oracle 9i only have 113 MB (by default)Which affects transaction speed very badly.I want to increase the memory manuallyIt shows error in GUI Also not able to increase memory by sql command

    mpw30520 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

    Desjacks5 pointsBadges:
  • Oracle Reports 10g error message

    SIr As soon i run the report through form in oracle 10g, its showing me the error which has code REP-51002 kindly resolve me this error

    Oracle2009mkd5 pointsBadges:
  • Can solaris8 on sparc architecture be virtualized, on the Oracle VM Server

    I have a solaris 8 system running a small oracle DB version 8 on the SPARC architecture. Which I would very much like to virtualize, including some small external SCSI disks.

    cbop535 pointsBadges:
  • MIssing views in apex installation

    I am trying to install a plugin in my current production of APEX 5. During the installation of the plugin it produce an error, Error at line 89: PLS-00201: identifier 'APEX_APPL_PAGE_IGS.DOWNLOAD_FILENAME' must be declared. And when i checked the view APEX_APPL_PAGE_IGS is missing. The application...

    azmiaj5 pointsBadges:
  • Extracting data from a long column data

    I have a table which contains the swift messages in a long column<COL1> in one of the tables<TAB1>.In the long data there is some field data starting with 121: <>.I have to read through the long data and find whatever is there after 121: .Plsql or SQL any solution will do .

    Barun2285 pointsBadges:
  • Free Chapter – Oracle on Linux, Analyzing Server Performance

    Another free chapter download is available on the IT Bookworm Blog. Written by: Darl Kuhn, Charles Kim and Bernard Lopuz Book: Linux Recipes for Oracle DBAs Overview: “Linux Recipes for Oracle DBAs is an example-based book on managing Oracle Database in a Linux environment. Covering commonly used...

    BrentSheets6,950 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:
  • Is Oracle compulsory for SAP HR or HCM?

    Is Oracle knowledge compulsory for SAP HR or SAP HCM?

    roopa1235 pointsBadges:
  • Microstrategy SQL

    Data Table : IE9_RX_Fact Table  Database Dictionary --RX_FACT_ID - Unique record id for each transaction --DSUPP_CD - Data Suppliers --SUPP_LOC_CD - Site ID --DSPNSD_LOC_CD - Pharmacy ID --OPR_SRC_BTCH_NBR - TDW loading batch no. --OPR_ROW_TYP_IND - Traceability for correction and regular supply...

    akosikhulaz10 pointsBadges:
  • Oracle vs Mysql, how they implement concepts of database.

    I am confused between oracle and mysql how they implement databases philosophy. In oracle is user means database and in mysql why do we have only root password unlike oracle. Is database more secure in oracle compared to MySQL.

    Tech2rp15 pointsBadges:
  • SQL Command in Oracle

    How can I get all the tables I have created in Oracle ?

    Sariful5 pointsBadges:
  • Error on installing Oracle 10 software where Oracle 9i software already exists

    Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...

    Wbuker0 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • Query to get Oracle object changes

    I need to obtain a listing of Oracle object changes that have occurred during the year. Does someone have a query that I can use?

    montymonty5 pointsBadges:
  • How to insert/delete/update data into VIEW using forms 6i

    i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?

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

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

Following