I have to create a dblink from oracle to MS ACCESS.
1)I have added in Tnsnames.ora
hsodbc=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ecoletti)(PORT=1521)
)
(CONNECT_D...
I have a table as follows that contains these columns:
preferred_surname, preferred_first_name, sibling_group_no.
I need to produce a report that lists all students alphabetically by pre...
Hi all
I have the following program to make: i need to check the correctness of a view text (i.e. that it references the correct tables)
for this i need to get the view text, but it is a l...
I am writing a package to process data into a schema and a requirement to store a timestamp as "no of seconds since 01/01/1970 UCT time" has surfaced.
I am not aware of any packaged procedure...
Hi
Platform : Oracle 9.2 / Windows 2000
I'd like to export a table with 40 million rows to a flat file. If I SPOOL data into a regular text file it grinds to a crawl after around 4 mill...
I have a Primary Key field with potential values from 1 to 99,999,999 - this field is a Foriegn key into a table with 2b+ rows . It is currently defined as a
number(8) , what are the implic...
TNSNAMES.ORA connection description :
Can anyone tell me the difference between the use of GLOBAL_DBNAME vs SERVICE_NAME and what to use when and why ?
Regards,
Ivan
Hi,
I have compiled and wrapped my stored procedure with oracle 8.1.6. However, when i compile it in 8.1.7, I encountered the PLS-00801 Internal Error [21076]. I believe it has something to...
I've an oracle 9.2.0.5.0 instalation on a windows 2003 server enterprise edition.
Almost everyday this server restart itself, do you have an idea what is happening?
There is some debate on using PL/SQL function calls inside SQL Queries. Despite of the fact that the Explain Plan functionality ignores PL/SQL function calls and that the function calling mec...
DATABASE CAN NOT STARTUP AFTER RESTORE
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\Documents and Settings\tauadm>sqlplus /nolog
SQL*Plus: Re...
I have a very interesting situation with Oracle export. We do a schema level export and it appears like it chooses conventional path on certain tables. I've checked the table and none of them ...
Hello I am a Bioinformatist trying to understand the rudiments of Oracle ....
I am starting off with installing Oracle on my personal machine (Red Hat Linux).As I am working through the ins...
Hello all, recently I Installed Oracle 10g XE on my Windows XP PC.
I tried ran this command (Charachter set was not OK):
ALTER SYSTEM SET NLS_LANGUAGE = 'AMERICAN_AMERICA.IW8PC1507' SCOPE...
trying to get a page break in repeating frames.
scenario is :
the query returns a set of addresses from various towns.
the data layout contains 2 groups under the query
group 1 for th...
To get Oracle Version.
How do I get the version of the Oracle installed using regedit? This is in case where the Oracle MTS Recovery Service is not installed.
Thanks and Regards,
Anurad...
I ran the utlrp.sql after installing a patch on my database and one of my objects came back as invalid.
How would I fix this? The object in question: UTL_RECOMP
I'm tyring to import a dump file that i exported from an Oracle database with version 10.2.0.1.0 and import it to an Oracle Database with Version 10.1.0.2.0
Is causing me some errors though...
Hi,
while migrating my database from MSSQL to ORACLE, i have to convert these DBCC statements to some oracle equivalent inbuilt functions...
DBCC DBREINDEX Rebuilds one or more indexes for...
is it possible to store russian characters in a oracle 10g database with characterset NLS_CHARACTERSET WE8MSWIN1252
and if not, in what characterset should the database be installed to allo...
I want to create a Oracle sql statement including a calculated field (boolean).
The following statement works well in MS-Access. But I have many troubles to make it work in Oracle.
Who know...
I need drop tablespace example becouse i have problems with disk space, i'm going to start droping 'example' tablespace created during oracle installation.
The problem is when i type:
dr...
Hi, All:
Now I want to upgrade from Oracle 8.1.7 to 9.2.0. How and where can I get some documents about this task, especially about the usage of DBUA tools?
Now, I have Oracle 8i install...
Hello Experts,
I am trying to create a table with name 123, but it returns me an error msg: ORA-00903: invalid table name. I googled ORA-00903, and it is an error for column names. Is there...
Hi, I'm an oracle newbie and may have waded out a little too deep, but here goes.
I'm using oracle 8.1.7 (oooold) and windows 2K
Over the past 2 months, oracle has crashed nightly. If i...
