|
-
[QUOTE][i]Originally posted by pwoneill [/i]
[B]Check out [url]http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/ch4d2.htm#37749[/url]
To modify a LOB you use
MODIFY LOB (lob item)
not
MODIFY (column name) LOB (column name)
The lob item is the column name.
Whenever you have a command syntax problem it's best and fastest to check technet's sql reference for your version of the database, you'll also learn more about it. [/B][/QUOTE]
I have tried the syatax as suggested by you.
ALTER TABLE (table)
MODIFY LOB(lob item)
STORE AS(tablespace);
I aam still getting the same error.
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
|