I am importing an schema called bond from production to dev.
I use the following syntax:
imp system/password file=$PIPEFILE log=${IMPORT_LOG} fromuser=bond touser=bond;
The output from log shows no error:
. importing BOND's objects into BOND
. . importing table "ADDRESS"...
In PL/SQL I can do the following in a batch statement
1 declare v_num int := 0;
2 begin
3 select count(*) into v_num from test_frag where rownum < 100000;
4 update test_frag set big_column = big_column where rownum < 10;
5* end;
/
PL/SQL procedure successfully completed.
How...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.