hi
i am new to oracle
i ve downloaded the files disk 1, disk 2 , disk 3
and i tried to install oracle standart edition on a computer running win xp pro with 2.4 ghz cpu and 512 mb ram
at ...
there's several times oracle in one of my servers ate all the memory.
first I thought it's maybe my code cause the problem, but then i shut down everything, wrote a simple asp page with only ...
hi there,
I have a problem when I try to connect the database from developer 2000, appear an error like this :
'f45des has caused a general protection error in module sql16w95.dll in 000...
Hi all,
Can anyone tell me how to solve oracle Export problem.I have Oracle 9.2.0.4 running on my desktop.When i export my database it exports tables,views and procedures very fast bu...
Hello Experts,
I am a regular viewer of the articles on the site, and recently got a chance to sign up as a user.
We have a table which is used to backup the main data, which is a compre...
Hello,
I need to use a commercial tool that creates tables in DB.
When I checked directly in Oracle the table created I could not see any contraint on it (via DBA console, No PK, no unique...
Hi and thank you.
What is the most efficient way to change a multi-database installation from a standard edition to an enterprise edition, and from an enterprise edition to a standard editi...
I have installed Oracle 8.1.7.0 on AIX 5L
but it failed to install lib folder, and keep prompting me error, so i ignored them and let the installation keep going
once the installation comp...
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...
Can anybody translate the following t-SQL code into PL/SQL code:
--CREATE PROCEDURE crosstab
DECLARE @select varchar(8000), @sumfunc varchar(100), @sumval varchar(100), @pivot varchar(100...
Oracle 9i using AUM
Can anyone tell me the average size of an UNDO tablespace?
hi,
is there any way to optimize this oracle update statement.
i needed to include the where exists clause so that it wouldn't update the non-matching rows to null. this kind of update happe...
Can someone explain to me what the component "Oracle Windows Interfaces 9.2.0.1.0" does? I am a training developer and I am currently developing some training based off of the installation pr...
When I try to open Net configuration assistant or Enterprise Manager console I get the follwoing message box
---------------------------
jrew.exe - Entry Point Not Found
-------------------...
Hi
Please tell me the code for outer joining of 2 tables using (+) operator in Oracle. No union or Full outer join keywords are to be used. i.e implementing Full outer join using (+) i...
ORA-12638: Credential retrieval failed
Cause: The authentication service failed to retrieve the credentials of a user.
Action: Enable tracing to determine the exact error.
how do I s...
I'm trying to install Oracle 8.1.7 Enterprise Edition on my desktop, a Dell OptiPlex GX280 running Windows XP Professional SP 1. Here's what I've done:
1. Clicked on setup icon in the bas...
I read the other posts related to setting db_block_size on WnXP Pro, but they don't pertain.
I want to make a second database that uses 16K block size. When I use the DB Config Assistant to...
Hi,
I'm facing a problem in making reports for Dot Matrix Printers e.g. EPSON. Problem is, I wanna print the report in high speed draft font which is normal a font in any dot matrix printers....
I am trying to connect to another computer with Oracle 10G, via internet.
I have defined a local service name, SRM, with the remote IP adress (which is a router/firewall), and port 1521.
...
I accidently truncated a partitioned table using SQLLDR. How can I get the data back for this table?
I have installed Oracle 9.2.0.1.0 and I cannot log into anything because listener is not active. I went through the Net Configuration Assistant but still could not get my listener running.
