Home » SQL & PL/SQL » Client Tools » SQL+/TOAD Differences ?
SQL+/TOAD Differences ? [message #195594] Fri, 29 September 2006 10:23 Go to next message
Balgarvie
Messages: 4
Registered: September 2006
Junior Member
I have the following DDL:

ALTER TABLE SCHEDULED_TASK_HISTORY
ADD CONSTRAINT SCHEDULED_TASK_HISTORY_PK PRIMARY KEY (SCHEDULED_TASK_HISTORY_ID) using INDEX TABLESPACE DBC_INDX_S
/

If I run this in SQL+ it fails, saying that the tablespace DBC_INDX_S does not exist. However the tablespace does indeed exist.
If I run it in TOAD, it runs correctly with no errors.
What is the reason for this, I would have thought that TOAD and SQL+ implemented SQL in the same way but it seems thats not the case.
Can anyone advise ?
Thanks
B
Re: SQL+/TOAD Differences ? [message #195664 is a reply to message #195594] Sat, 30 September 2006 13:36 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
My first guess would be you are connected to different databases. Probably you are using two different tnsnames, or your default database differs from the one you connect to in TOAD.
Previous Topic: TOAD FAQ
Next Topic: HOW TO USE ISQLPLUS ON STANDALONE PC
Goto Forum:
  


Current Time: Tue Dec 06 10:36:30 CST 2016

Total time taken to generate the page: 0.11372 seconds