Hi all,
I am trying to insert the data from one schema to other.
ukd is the user name i want to insert data into.There is no sequence of the name ukd.Even if i remove ukd, im still getting the same error.
But iam getting the below error:
ORA-02201: sequence not allowed here
ORA-06512:at line 11
declare
cursor c1 is
select owner,object_name from dba_objects
where owner =upper('&owner');
begin
for var in c1 loop
EXECUTE IMMEDIATE 'insert into ukd.'||var.object_name||'
SELECT * FROM '||VAR.OBJECT_NAME||'';
END LOOP;
commit;
END;
Message was edited by:
MYH