How to see relationship table in Oracle using TOAD,
because i must to see relationship to make view of tables..
because not me build the database and make tables,
but I have job to make ...
Hi,
I don't really have Oracle background. I'm using Oracle 9i. May I know how to increase maximum number of processes? I need to increase it to 400. I got this ORA-00020: maximum number of...
experts,
i ran one database script from os(unix) using nohup. i got unix process id. now i want to check the status of
my script in the database. how do i check it.
i want to find orac...
I don't get the output of "dbms_output" to the spool file tmp.log.
All I get is this: "PL/SQL procedure successfully completed."
How do I get output of pl/sql procedure into sqlplus spoo...
Hi
I have created a datatype that contains a BLOB attribute. I want to run the select * from table_name query in SQL PLUS. I get an error saying that the field cannot be displayed in SQL PLU...
Hi,
The link below said number 32000 is the max limit number of processes
that can be set in Oracle 10g :
http://forums.oracle.com/forums/thread.jspa?threadID=540004
The number of Orac...
How can I return a result set from an Oracle procedure or function as a table?
I can do this in MS SQL like the following example no problem:
CREATE PROCEDURE dbo.GetMyStudents (@userID ...
I am using Oracle 8i on SunOS 5. It is a datawarehousing system
I got the following error while running an application
alter table abc split partition PHMMAXVAL at (to_date('2008JAN...
Our server cannot start oracle enterprise server 7.2.2.4 on SCO Unix 5.0.4,
because log1orac.dbf is corrupted:
>startup ...
I'm stumped... I just tried to install 9i release 2 on my laptop.
When I click on setup.exe, the cd spins for a while then I get an error window.
Title bar say 'Java Virtual Machine Launch...
I want to change the default value of the columns in OPracle 10g database. I want to be able to set the value to " " and 0 if the dependant on the column datatype. I want to be able to generat...
Hi all,
I need to upload 7000 employee pictures into Oracle database. I have the pictures in the format employeeid.jpg. The pictures are into directory machine. I need extract the pictures ...
I tried to use Oracle thin jdbc driver. the following segment is what I used:
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
...
Is there any variable through which we can control oracle session time out period
I have a select statement that uses a LONG datatype in the where clause and is producing the following error
Error on Select - ORA-00932: inconsistent datatypes: expected NUMBER - got LONG :-...
Hello there,
i am trying to connect to a remote oracle 10g db.but i get a ORA-03135 error.there is no firewall on that server.other computer on the netwrok can connect to the db.i also ha...
Hi,
I've been using Sybase for a few years and now I'm working on Oracle, so I need some help with translation.
In particular, the following Create Trigger is giving me 'MGR-00072: Warn...
I have exported TableA to tableA.dmp.
I cann't drop or truncate table 'TableA', so I want do import to another table 'TableB'
In otherwords,
Is it possible to import data into a diff...
i want to change the format of a date using the function:TO_CHAR OR TO_DATE to this format:
from dd-mm-yyyy
to: month, date(th) yyyy
ex: january, seventeenth 2003.
Error 6 initializing SQL*Plus
Message file sp1<Lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
i got this error when running sqlplus.. does...
I was trying to execute a query which is containg a clob datatype. and give out error message
ORA-00932: inconsistent datatypes: expected - got CLOB
query:
select emp_id, comments fro...
Dear experts:
Hi,
I would like to insert into a table(using spl plus 9i) multiple rows of values.
I know how to insert a sinle row.
The following is a code that I tried to use:
i...
Hello All,
I am using nvarchar2 data type to support multi language in my table for 10g oracle database.
I want to set it maxlength to 4000.
But my oracle database 10g supports only AL1...
Oracle 10g on Windows 2003 server
The Oracle Listener just went down and I cannot start it back up.
When I try starting the LISTENER from services.msc I get:
Error 1067: The process ter...
I am making a copy of our production database on another server and I am trying to give this new instance the DB name "IQ1", but I am getting the following error message when running the creat...
