Insert into one empty table from another table

Hi,
I have one empty table emp_1,
SQL>desc emp_1;

Name Null? Type
------- ------ -------

EMPNO NOT NULL NUMBER(10)
ENAME NOT NULL VARCHAR2(50) Another table is emp_2

SQL>desc emp_2;

Name Null? Type
------- ------ -------

EMPNO NOT NULL NUMBER(10)
ENAME NOT NULL VARCHAR2(100) SQL>select count(*) from emp_1;
COUNT(*)

      0

SQL>select count(*) from emp_2;
COUNT(*)

    1000

So, the only different is ENAME is varchar(100); But I want to keep them, I only want emp_2 data into emp_1.

Does somebody can give me the SQL script for transfering the data or using exp/imp.

Thanks a lot

Paul

--
Posted via CNET Help.com
http://www.help.com/