ORA-00997: illegal use of LONG datatype during create table as
977981Dec 4 2012 — edited Dec 5 2012hello I need to create new table with structure like other one chosen by me. I've got table Countries(Country_id char, country_name varchar, region_id number) and while compiling :
create table countries_copy as (select * from all_tab_columns where owner in('HR') and table_name in ('COUNTRIES'));
i'm always getting error:
ORA-00997: illegal use of LONG datatype.
what i need to do?
P.S. sorry for my english.