Pass sql into pl/sql and create RMAN duplicate script.
Posted on
16th Feb 2014 07:03 pm by
admin
Hi,
I'm new to pl/sql and I'm trying to write a script that will generate some RMAN commands to do a database clone.
Did you know?Explore Trending and Topic pages for more stories like this.
I want to able to run the script and it prompt me for variables to be used in the script.
I've done some research but I've been unable to find any examples of how to do this.
Basic script is (there would obviously be a lot more to the final script):
declare
dbname varchar2(9) := &dbname;
BEGIN
DBMS_OUTPUT.ENABLE(2000);
DBMS_OUTPUT.PUT_LINE(' DUPLICATE TARGET DATABASE TO '|| dbname ||';');
end;
/
Gives me:
Enter value for dbname: ORCL4
old 3: dbname varchar2(9) := &dbname;
new 3: dbname varchar2(9) := ORCL4;
dbname varchar2(9) := ORCL4;
*
ERROR at line 3:
ORA-06550: line 3, column 24:
PLS-00201: identifier 'ORCL4' must be declared
ORA-06550: line 3, column 9:
PL/SQL: Item ignored
ORA-06550: line 7, column 66:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 7, column 9:
PL/SQL: Statement ignored
Thanks,
No comments posted yet
Your Answer:
Login to answer
277
49
Other forums
PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am
login to other site by sending post variables
hey,
here is my problem: my school gave me a mail account for school-stuff use. they mail us
How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [
some questions
Hello,
I am looking for the answers for following questions:
1) Does PHP support overl
need help in mysql_num_rows()
please tell me what i am doing wrong in this query. it displays this error
Code: Warning: mys
Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm g
(sub)screen resize modification doesn't work after ECC 6 EhP 4 installation
Hello,
We have previously extended the size of the custom data tab on PO transaction ME23
Calculating n! using vector
#include
#include
#include
using
Cloud Computing?
Hello,
I was wondering if anyone could help explain this term to me. I'm starting to hear it
newbie error
what is wrong with this code ?
<html>
<body>
<?