create table as <to remote database>

I have two database servers
one with Oracle 9i - (users abc)
one with Oracle 8i - (users abcd)

from the 8i server i write a create table statement as

create table userdata as select * from abc_at_oracle9.userdata.

userdata is a table available in the user area abc on oracle 9i. I have created a tns entry with oracle9i - and is working successfully.

but still when i issue that command is says insufficient information to connect to the remote database.

please help me....

--
Posted via http://dbforums.com