Hi All,

I'm trying to create a table dept_bk as


create table dept_bk as select * from dept.

dept has only 4rows

i'm connect as user scott

i have connect as sysdba and granted user scott unlimited space in default tablespace users, i have queried the dba_free_space to see whether or not i have space in users tablespace, there is 26148864 space available.

y do i get the error "end-of-file on communication channel?

Please help

thanks

Tom

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Oracle LazyDBA home page