Re: What is wrong with this?
select sys_store_id.nextval from dual; [EMAIL PROTECTED] wrote: Hallo, I have this sequence, CREATE SEQUENCE SYS_STORE_ID START WITH 1 INCREMENT BY 1 NOMAXVALUE NOCYCLE CACHE 10; I am trying to run this script, sys_store_id.nextval: but get this errormessage: unknown command beginning SYS_STORE_... - rest of line ignored. How can I solve this problem? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Vs DB2
hi! db2 sites which i can strongly recommend are http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main and http://www-3.ibm.com/software/data/db2/os390/v7books.html i guess you will have a close look at V7 and V8, but V5 and V6 are also there and even V4 for MVS. daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: newbie sqlplus ?
hi! in your profile set $ORACLE_HOME to your oracle directory and put $ORACLE_HOME/bin in your path daniel Les Ayudo wrote: I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued the command sqlplus and I rec'd a command not found error. Is there something I forgt to do before the install? Let me kow if u need more info. THanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: converting NT batch files to Unix shell
hi sree! since the shells (whether korn, bash or any other) are very powerful and cmd.exe is a rather poor thing, i would suggest the following: either: find someone who is capable of shell programming and has been on NT or can read the screen after typing HELP in cmd.exe he will have no problem with it or: make a step by step discription of what the script is supposed to do and give it to the shell programmer. daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dump table to file, edit and reimport
hi! unload and load work like that SQL exp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable) SQL imp myuser/@mydb file=C:\temp\mydump.dmp tables=(mytable) but i don't think you will have a good time editing the file. if you want a | delimited file, you should use spool and gerenate the file you need. daniel Aidan Whitehall wrote: In Sybase's ASA there was an unload command which wrote to a text file the SQL to recreate a table, along with all it's data which running the SQL then imported. This allowed you to very easily dump a table, edit it's structure and suck the data back in. The closest thing I've found in Oracle is right-clicking on a table | Data Management | Export. However, we're not running the Oracle Management Server (just because we don't know how to set that up yet), so this functionality isn't available. Barring installing OMS, is there a quick and dirty way to do this? And, if the answer is no, is OMS easy to set up? Thanks! -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Aidan Whitehall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ReInitiate Sequence Number
hi hamid! what about doing it with by twice altering the sequence: /* create the seq */ SQL create sequence myseq nomaxvalue nocycle nocache order; /* reset the seq */ SQL select myseq.currval from dual; /* assume that curval = 6 */ SQL alter sequence myseq maxvalue 6 cycle; /* back at 1 */ SQL select myseq.nextval from dual; NEXTVAL -- 1 /* back to normal incrementation */ SQL alter sequence myseq nomaxvalue nocycle nocache order; khoda hafez! daniel Hamid Alavi wrote: Dear List, How can I reinitiate a sequence Instead or dropping recreating it, I want every night my sequence number reinitiate and start from 1 again. Thanks for your help. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: strange behaviour of sequence
hi j.p.!
try with
SQL create sequence testseq start with 1 NOCACHE ORDER;
regards
daniel
oraora oraora wrote:
Guys,
one of my developers is using sequence to auto-increment the value
of a column while inserting.
he has created a sequence like this.
SQL create sequence testseq start with 1;
and then uses a INSERT statement as below in a JSP.
insert into testtab values ('BREAD'||testseq.nextval);
after some inserts .when he does SELECT from TESTTAB...he
finds
the values as :
BREAD1
BREAD2
BREAD3
BREAD4
BREAD21
BREAD22
it should increment by 1.but it is not so ?
any hint/clue
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Help with procedure
bryan!
please provide the errors, you can query them with
SHO[W] ERR[ORS] ...
daniel
Bryan, Miriam wrote:
Hi List, I'm hoping someone can help me. I'm trying to compile a procedure,
which calls another procedure and I keep getting an error on the first end;
can't figure out what's wrong. Perhaps someone that hasn't seen this
procedure for hours can tell me what's wrong.
The user has all the right privileges.
Here's the code:
CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin
AS
--
--
-- Purpose: Convert Agent_Activity.Admin table to Employee_Activity
-- User_Info and User_Security_Group.
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- - -- ---
-- psurring 1/20/03 Initial implementation
--
err_num NUMBER;
err_msg VARCHAR2 (100);
V_SECURITY_GROUPUSER_SECURITY_GROUP.SECURITY_GROUP_ID%TYPE;
V_BRANCHUSER_INFO.BRANCH%TYPE;
CURSOR get_admin
IS
Select username,
password,
level_,
center,
first_name,
last_name
From AGENT_ACTIVITY.ADMIN
Where upper(level_) in ('CENTER','TEAM','GROUP','PAYROLL');
BEGIN
FOR x IN get_workgroups
LOOP
begin
if upper(x.level_) in ('CENTER','TEAM','GROUP') then
v_security_group := 4;
else if upper(x.level_) in ('PAYROLL') then
v_security_group := 2;
end if;
if x.center = 'TX' then
v_branch := '7';
else
v_branch := 'G';
end if;
EMPLOYEE_ACTIVITY.ADD_USER(x.username,
x.first_name,
x.last_name,
x.password,
v_branch,
null,
'SYSTEM',
v_security_group);
EXCEPTION
WHEN OTHERS
THEN
err_num := SQLCODE;
err_msg := SUBSTR (SQLERRM, 1, 100);
ROLLBACK;
insert into Application_error (USER_NAME,
ERROR_DATE,
PROCEDURE_NAME,
SQL_ERROR_NUM,
SQL_ERR_MSG,
PARAMETER)
values
(v_LAST_UPDATED_BY,sysdate,'EMPLOYEE_ACTIVITY.ADD_USER',v_err_num,v_err_msg,
'v_USER_NAME='||v_USER_NAME||
'v_FIRST_NAME='||v_FIRST_NAME||
'v_LAST_NAME='||v_LAST_NAME||
'v_PASSWORD='||v_PASSWORD||
'v_DEFAULT_BRANCH='||v_DEFAULT_BRANCH||
'v_DEFAULT_WORKGROUP_ID='||v_DEFAULT_WORKGROUP_ID||
'v_LAST_UPDATED_BY='||v_LAST_UPDATED_BY||
'v_SECURITY_GROUP_ID='||v_SECURITY_GROUP_ID);
COMMIT;
RAISE;
END;
END LOOP;
end;
/
TIA,
M. Bryan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: newbie question - still: please help
thanks a lot 4 your replies. /*i followed the way dick and mark suggested.*/ daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
newbie question - still: please help
hi! a DBA inteds to speed up a script that is looping and sending hundred thousands of sequential update statements like: UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n; he suggests copying the table to a file, change it and then load it into the DB again. i am strongly convinced that this is nonsense. what is the best way to go for a script like this, doing tons of updates? (except convincing him to swith to sell burgers) thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
blob deletion
hi gurus! can anyone answer this (maybe newb question:) i have a table with a BLOB column. this table is stored in a seperate tablespace, in which there are no other data than that of this very table. suppose now i have one row in this table. if i delete this row, the blob is also deleted and tablespace increases. on a different DB with the very same data, the DBA claims that deleting the row with the BLOB does delete the row from the table, but the BLOB remains in the tablespace and the diskspace he takes cannot be reused. if i create my tablespace (without auto-extend) sized 1 MB and i insert a row with one BLOB of size 800 KB, the next time i can't insert another row with a BLOB of that size. - fine. if i delete the row, i can insert another row, again! - fine. but the DBA of the other DB claims: if he deletes one row, he cannot insert another row, because the BLOB is not acutally deleted. ? ? ? thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dates
hi imran! don't exactly understand what you want to do, but rounding e.g. the year works like that select round(to_char(sysdate, ''),-2) from dual; i dont understand what you wanna do with days and months, but if its always 01-01 then select '01-01-'||round(to_char(sysdate, ''),-2) from dual; will do. regards daniel Imran Ashraf wrote: Hi, how do i round dates like this: Date = 01-01-1996 Return = 01-01-2000 or Date = 01-01-1992 Return = 01-01-1990 Thanks. __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dates
hi!
then i think this is what you need:
select to_date('01-01-'||round(to_char(sysdate, ''), -1),
'DD-MM-') from dual;
reg.
daniel
Imran Ashraf wrote:
Im running this query:
select round(add_months(sysdate,500),'')
from dual;
This retuns:
01-JAN-2044.
I want it to return:
01-JAN-2040.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
to_char(sysdate) problem on 8.1.7.
hi! 8.1.7. on WIN: due to a bug - it seems - the following query returns an error: SQL SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual; SELECT TO_CHAR(SYSDATE, 'dd.mm.') from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [538241312], [], [], [], [], [], [] while it works fine on 8.0.5. and 8.1.6.! does anyone know a way to change the query, so it will work on all version and there is no need for a patch? tia regards daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Free ware databases: which are worth the money?
hi! i can strongly recommend PostgreSQL. i have worked with it modelling data for a java application and perl cgis using it. it supports transactions, functions in pure sql, a procedural language similar to PL/SQL etc. etc. and is very robust. the only thing i miss is handling tablespaces as on oracle. i have sofar only used it on debian, but it should also be fine on other linuxes and some elitist bigots work with it on sun. there is also good literature and a very good o'reilly book on it. on the web htpp://www.postgresql.org regards Mark Teehan wrote: Hi, we are investigating some freeware databases for deployment on systems that dont justify the cost of an oracle license, on linux. What databases out these can cope with a OLTP load, all transaction based, with some reporting? Uncomplicated databases, with mid size volumes of transactions (say low millions) and some reporting queries? I guess reliability is the primary concern, if something can be built as solidly as an oracle instance, with whatever OS protection this would need, then its a starting point for making a non oracle freeware enterprise database. Anyone have any suggestions on what I should download first? Thanks! Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: naming conventions for Oracle/Unix vs. SQL Server
hi! from my experience of haveing the same data or data model on different DB brands and platforms it is wise wiser wisest - cause you never know what the management is going to buy next - to stick to the following naming conventions for identifiers: + all identifiers in uppercase + not more than 30 chars (even if MS$SQL offers you 128) (if there's an old DB2 on the mainframe around, even: 18) + start with a char + do NOT - even not in quotes - use reserved words: INSERT, VIEW etc. + be careful with other characters than letters and numbers many developers use '_' only this will make life easier daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
JBDC thin driver
hi! anyone knows an answer to this: i want to user JDBC thin driver. i can install it from the CD on windows using the manually configured installation. since thin driver is said to be purely java, i want to use it on linux, too. which are the necessary files? are they in $ORACLE_HOME\jdbc\lib\classes111.zip could not find help in metalink thx regards daniel -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Install Oracle 8i on Windows XP?
i am sorry i have to give another reply to the WINDOWS issue, quoting also a cultural superior american named frank zappa -- all that we got here's american made it's a little bit cheesy, but it's nicely displayed well we don't get excited when it crumbles and breaks we get on the phone and call up some flakes they rush on over on wreck it some more and we are so dumb they're lining up at our door (from Sheik Yerbouti, Flakes) -- forgive me for this mail and delete it daniel Jacques Kilchoer wrote: Mr. Pierce - the only ad hominem attacks I saw were from you. Someone posted Don't use Windows, a generic disparagement of the operating system. You immediately responded with a personal insult calling the person an asshole. You then followed it up with a post asserting the cultural superiority of Americans and Israelis over the rest of the world. I suggest that you refrain from personal insults and from political diatribes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] from a private message: | Suggestion: make it clear to the elitist unix bigots that if they | intend to regularly engage in ad hominem attacks and insults that | are clearly intended to disrupt the purpose of the list, which | would include people discussing oracle technology on windows free | of irrelevant b.s., it will be considered a violation of list | rules. | | I delete 98% of posts that are unix/mainframe related, why can't | the unix people do the same thing, and simply focus on what they | are interested in instead of interfering with other people's | conversations? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Moving tables from one schema to another
hi! if it's just a few tables you can use copy copy from x/x@db to y/y@db create table_name using select * from original_table if thats not handy i would EXP the scheme and import it with imp y/y@db file=/path fromuser=x touser=y then drop the old scheme regards daniel [EMAIL PROTECTED] wrote: Hi I have a user with a schema and want to move that schema to another user. I don't need the original user after the change Can I do this without an export/import. All data and tables in this database I care about is in this schema Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL query
hi vandana! use DESC[RIBE] TABLE NAME regards daniel Vandana wrote: I am using an Oracle database running in Linux. I would like to view the description of a table. For ex., if there is a table called 'person'. I would like to see the names of the columns in this table, their datatypes and such other details. In other dbmss like mysql a command 'describe tablename' gives the information. What is the equivalent in Oracle? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vandana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
getting binary BLOB data
hi! i want to write blob data (binary) into a file on 8.1.7. UTL_FILE package is for text data only. is there a possibility to do it with PL/SQL or is a C(OCI) function required??? n.e. 1 experience with it? thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PostgeSQL?
this maybe true in terms of administration, but not in terms of object manipulation: handling sequences, writing pure SQL functions etc. are really good stuff. also to be implemented into ORA one day i hope crucify me, thats my opinion daniel Alexandre Gorbatchev wrote: since oracle is not as handy and clever as PostgreSQL is, at the moment, there is no other way than to drop the sequence and create it again. Since PostrgeSQL is not as reliable and scalable as Oracle is, at the moment, I wouldn't, from DBA perspective, use it for any seriuos project. :) and there are not many developer's tools. :) but it would be a great new feature for oracle 10.5.7.4.3. I would better vote for other new features... :))) Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Count rows in textfile
hi roland! if you're on unix and have bash use $ wc which has a lot of super options, see -- $ man wc i think it's the same on ksh too, but am not sure. if you're on w3, i would either install cygwin, then use can use bash, too, or write a little perl script daniel [EMAIL PROTECTED] wrote: Anyone whom has a good example on how to check how many rows (without opening the file) does a text file consists of? What is the command? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: change a database connection in a stored procedure?
hi! i don't quite understand the problem, but it seems that while running a script you want to build a second connection you can do this if you build the connection with HOST SQLPLUS xxx/yyy@zzz with the first EXIT you disconnect from connection 2 and with the second one from connection 1 bye daniel kranti pushkarna wrote: Hi Sergey, I am using dynamic SQL but it is returing error for connect statement. Can u give me some example code. Rgds Kranti -Original Message- Sent: Tuesday, May 07, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Hello kranti, Use dynamic SQL. Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kranti pushkarna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
bitmap indices
hi! to speed up queries i have created a bitmap index on a column that contains 2 chars as a maximum. to my surprise the bitmap index does not make the query quicker than the 'usual' B-tree index, though there are only bout 100 different values in half a million rows. has n.e.one got experience with bitmap indices? are there any further poosibilities to adapt them when creating??? tia bye daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sql monitor
hi! i am looking for tools to monitor the SQL of an application that connects to oracle to analyse it. whichs tools are available? who has experience with them??? tia bye daniel -- Daniel Wisser, Mag. ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
