_data_files@:b1';
> > >
> > > Changing it to this might work (I've not checked it myself so no
> > > guarantees)
> > >
> > > exec_string := 'select sum(bytes)/1048576 from
> > > dba_data_files@'||remote_db;
> > > execute
f so no
> > guarantees)
> >
> > exec_string := 'select sum(bytes)/1048576 from
> > dba_data_files@'||remote_db;
> > execute immediate exec_string into db_size;
> >
> > T¬
> >
> >
> > -Original Message-
> >
t you dig that out and close the db link after you've
> done the
> select.
>
> T¬
>
> -Original Message-
> From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
> Sent: 21 March 2003 09:48
> To: Tim Onions; [EMAIL PROTECTED]
> Subject: RE: Passing DB-Link name in a Loop
>
lf so no
> guarantees)
>
> exec_string := 'select sum(bytes)/1048576 from
> dba_data_files@'||remote_db;
> execute immediate exec_string into db_size;
>
> T¬
>
>
> -Original Message-
> From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
&g
Hemant
In case nobody has yet replied I believe your error is that you cannot use a
bind variable in an execute immediate for the db link name as you are trying
to do with this statement:
exec_string := 'select sum(bytes)/1048576 from dba_data_files@:b1';
Changing it to this might work (I
Guys,
help me here.
This SQL [below] returns the error :
connecting to AM3C01
declare
*
ERROR at line 1:
ORA-01729: database link name expected
ORA-06512: at line 16
[AM3C01] is the first db_link fetched.
tti 'Database Sizes (excluding TEMPFILEs) ' center
spool DB_Sizes
set serveroutput on s