I am planning to buy Oracle 10g Standard Edition One (5 user Licence).Just had some queries on that.
1>Is incremental backup supported by this edition.
2>Is oracle mirroring supported by t...
I have an oracle collection type:
CREATE OR REPLACE
TYPE pdf.tab_todim
AS TABLE OF "PDF"."TODIM_T";
where TODIM_T is a object-type:
CREATE OR REPLACE
TYPE pdf.todim_t as o...
Oracle DB has been popular on Solaris with Sun SPARC platform. Now it seems like being shifted to Linux instead. Assume I have a Oracle DB size > 300GB, what UNIX platform (Solaris, AIX, HPUX...
Once I am connected to an Oracle 9 DB I need - probably thru DBLINK - to access to some tables on another ORACLE DB located into another Oracle server.
I have done some changes in the tnsn...
Ca anybody tell me why the following statement does not work.
FORMS_DDL(' ALTER USER '||:Block.Username||' identified by '||:block.newpassword)
I keep getting a 28001 password expire mes...
Below is the contents of my tnsnames.ora
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
WEBIF_DEV.WORLD...
Is the Oracle Migration Workbench a tool that can only be used 1 time or can you use it to migrate data from another database such as Mysql to Oracle on a continous basis?
Is there a portlet or some other way in Oracle 91AS Portal to send an e-mail notification when a new document has been uploaded to the Oracle database?
I have a table ( name: trace ), part_id and id are primary key, out_qty and in_qty are two column, I want to update out_qty or in_qty( make out_qty=in_qty=max(ouqty,in_qty), so I write followi...
Dear Expert,
I am doing some risk analysis for time-syn project for all Oracle DBs in Data Centers. There are 2 core Oracle DBs on both AIX (5L) servers (Running Archive Log Mode) and ther...
Our Oracle database contains binary fields that currently can only be viewed and some can also be printed from our ERP product (Visual Manufacturing). I would like to access these fields for ...
I created the following view:
CREATE MATERIALIZED VIEW HOLDINGS_MVIEW as select SITE||'-' ||NAME as ACCESSION_N, ID, PDF, TITLE, AD, P_REPORT, M_REPORT,PRICE, INFO, F_NAME, CONTROL from hol...
Hi,
In PL/Sql, how to include a new line in a text item. Is it char(13) or /n?
Thanks
also, does it have the limit of 255 charactors? if yes, how to get around it?
Thanks!
Ok I have a question about how oracle works. I have a oracle database which I want accessible from two different systems. BUT I only want one system to see a subset of the information IE:
...
Hi there,
I am runng a primary database and a standby database with 8.1.7.4 on 2 separate win 2k server. I have the standby database in managed recover mode which is working fine.
Our c...
i have installed 9i database and it is working well but the problem is in the form developer
it dose not connect to the database and gives me this error "TNS unable to connect to destination"...
Hello, I'm new to Oracle and my client wants to convert the backend of an asp.net/sql server 2k application that I built for them to Oracle 9.2.
I would like to purchase a license of Oracle...
Is there any way in Oracle for checking whether a table exists in the db or not i.e Oracle equivalent to the following in MS-SQL.
if exists (select * from dbo.sysobjects where id = object_i...
I'm using Procedure Builder and when I try to Save (compile) changes that I've made to my code, I often get a Stored Program Unit (PL/SQL Editor) error:
PDE -USW002 The source of the stored ...
I installed Oracle 8i on Sun Solaris 8. The installation completed, the link completed, but when it got to creating the database it couldn't complete. I don't remember the error I got at the...
Hello,
I need to create a tablespace.
I am supposed to define approximatively the size of a tablespace.
To do this. I have all the tables definitions, and an idea of the number of data ...
here's the step I usually go through to backup daily data:
exp
Username: "fin/fin@ora"
Enter array fetch buffer size: 4096 > "I press enter"
Export file: EXPDAT.DMP > "c:\todaydate\fin...
Hi,
Oracle 9.2.0.5
Other than recreating the table and index, is there any other method to reduce number of extents and chanined rows.
TIA,
Rakesh
We recently experienced a hard drive failure that caused our control files for our oracle 8i db to become corrupted. We tried several different things to attempt recovery (ie, changing from c...
