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
vasuv 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.