-
I am getting a : ORA-00933 :SQL command not properly ended error
When I attempt to select from a specified partition of a table. My query is
Select * from Cust (Part1); -- This will fail with the above error
I can run Select * from Cust; -- This will run
And yes this table has 3 partitions and one of them is Part1.
Any idea what is causing this query to fail?
Thanks
G.Ram
-
have u tried
Select * from Cust partition (Part1);
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|