| SQL+/TOAD Differences ? [message #195594] |
Fri, 29 September 2006 10:23  |
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  |
Frank
Messages: 7901
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
