vasuv 0 Newbie Poster
Hi All,
    I am working on Oracle 11.2.0.3. and my requirement is,
    I have a table in Development(Dev)  called " Dev_EMP".  
    Have created Synosym for "Dev_EMP" as  "SY_DEV_EMP"

    here is the structure 
    [/code]
    create table Local_emp
    (
      tran_id  varchar2(10),
      acct_id  varchar2(15)
    );
    [/code]

    2. Table which I am planning to access from Production is as below.

    create table c_emp
    (
      tran_id  varchar2(10),
    ex_ind  varchar2(20),
    f_id      varchar2(20)
    emp_stud  clob
    );
    [/code]

    Now the requirement is 

    would like copy  "ex_ind","f_id" columns from PROD to DEV table i.e"Dev_EMP" alias  "SY_DEV_EMP" and load the data to these columns data from Production table "c_emp" to Dev Table. 

    /*I gave the ALTER statement as below to add columns.

    ALTER TABLE Dev_EMP ADD ex_ind VARCHAR2(20) ;
    ALTER TABLE Dev_EMP ADD f_id VARCHAR2(20) ;

     INSERT INTO Dev_EMP(ex_ind,f_id)
       select ex_ind,f_id from c_emp@DL1;*/

    ERROR : TABLE OR VIEW DOES NOT ESIXT.-- But have alreadt created the table and Synonym also created. but getting this error. Advise how to write ALTER.

    3. advise query/procedure to load data from PROD to DEV table.

Thanks