1 person found this helpful
The following, with 11 columns, works fine using SQL Developer 4.1.3 against an 11g XE database:
create table hr.employees_dup as select * from hr.employees where rownum between 1 and 10;
That statement was executed while actually connected as HR. Please share more details about your test case such as...
1. SQL Developer version
2. Whether you connected as DBO (a misleading SQL Server reference?)
3. Differences in column data types between the 8 vs 8+ column test cases.