NachrichtHi Josef, I could reproduce that behaviour with 9.2.0.1 and sqlplus. It seams to be the problem of the "not_existing_link" or better the missing ...
NachrichtHi All, I am getting this error when I try to do explain plan in Toad 7.X version. My Oracle is 9i release 9.2 ORA-00904: "PARTITION_STOP": invalid...
Sarada Priya
saradapriya@...
Mar 1, 2004 2:48 pm
21716
sounds like you have a plan_table from some older version of Oracle installed on your 9i database. you need to drop it and create a new one from...
Is there a way in version 7.5.2 to set the schema browser as your startup screen? Thanks Linette Knuff Information Analyst AMIG Corporate Information ...
Linette Knuff/AMIG
LKnuff@...
Mar 1, 2004 3:11 pm
21718
Yes, go to Toad Options --> Windows And set SB as the only Auto Open Erwin Rollauer, ISR, McGill University, 514 398-5023 ex 00626 ... From: Linette Knuff/AMIG...
even when I try create or replace view blah as select * from not_existing_tab@existing_link in sql plus, I get "view created with compilation errors" but in...
Thanks for letting us know about what you're doing with TOAD! ... From: nibeck [mailto:nibeck.mike@...] Sent: Wednesday, February 25, 2004 8:10 AM To:...
Hi Sarada Normally this error number is raising "Invalid Column Name". I think this URL will help http://www.oracleadvice.com/Tips/plantip.htm Regords ...
Hi All, I am getting this error when I try to do explain plan in Toad 7.X version. My Oracle is 9i release 9.2 ORA-00904: "PARTITION_STOP": invalid identifier ...
Sarada Priya
saradapriya@...
Mar 2, 2004 1:14 pm
21723
Hi - I have a view I created. In the schema browser I can click on Columns and Scripts, but when I click on Data, it seems to take forever but eventually I ...
I think in the version you have, TOAD will try to determine if the view is updateable, and if so, attempt to return the rowid's. This may be causing a problem...
I get that error when there's a BLOB or CLOB field in the result set. If that is the case, don't include that field in the SELECT statement of the VIEW. That...
I don't wanna start talking contract stuff, but if you bought toad last sept., then there's a good chance you also have a valid support contract, which would...
Good. We don't want you guys to even come close to contracts. If you read too many contracts your skin gets scaly and you turn into Marketing Minions. Erwin...
That's exactly correct. It's not unusual to forget to recreate explain plan tables after an Oracle migration, especially if people have created their private...
Yes, we do have a support contract, so I suppose I could upgrade. I didn't know about that, so thank you. And thank you for explaining about the updateable...
You're welcome. The updateable view is just a guess as to what your AV might be being caused by. If you upgrade and still experience the error, we'll either...
Hello, By a show of hands please, how many people have successfully used command line compare of schemas in several databases with baselines, ie Db 1 sch1...
I'm trying to learn the SQL Loader part of Toad, and found one little problem: I can't get Toad to find the SQL*Loader on my computer, which causes the...
1) what is the error that you are getting? 2) what version of TOAD are you using? ... From: Gabriel [mailto:exorchan@...] Sent: Tuesday, March 02, 2004...
Have you gone to Toad options -> Executables Click on the flash light next to the sqlloader line. If that doesn't work then ask your DBA where the sqlloader...
Thanks, but I already tried that. Toad can't find it, and I don't know the name of the file to look for. DBAs are off doing something offsite, so I can't ask...
SQLLDR.EXE, though for 8.0 I think it was SQLLDR80.EXE. If Autofind can't find it, chances are you don't have it installed on the client. It's available on...
Mark, forgive me for interjecting here, but you should mention that sqlloader is on the Oracle Client CD. Some shops install the Oracle Developer CD but may...
Good point, thanks Joseph.. ... From: Joseph Charpak [mailto:jcharpak@...] Sent: Tuesday, March 02, 2004 2:04 PM To: toad@yahoogroups.com Subject: RE:...
and of course also if they are on unix there will be a sqlldr.exe on the server too - not just one that TOAD can run :) but they could use toad to create the...
what you guys need is a telnet client that can accept a script file and can accept a username, password, ip address as command line options. Of course...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
