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
Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo
Spaghetti Code
So.
I've pretty much reached the point where I have so many isset s on one page that I can't
Alternate messaging
I have 4 strings in MySQL db1
$string1 : Hello
$string2 : Hi
$string3 : Great
$strin
need help modifying script
Hi guys,
I'm fairly new to php and am having a bit of trouble modifying a script.
This
PHP Thumbnail Creation
Ok so i use this function to create thumbnails:
Code: [Select]function createthumb($name,$fil
Table control is disappearing from Screen
Hi Experts,
I have a screen with multiple table control(TC). Each table control has two c
Points for Wiki contribution
Hi everyone,
I want to know how long does it take for the moderator to award points for a
Is there something wrong?
Hi all,
Just a quick question... can someone look at this code and see if something is wrong?
random generation
hi
i need help with generating this
numbers from 1-12
i want to generate in ran
ASP.NET Validation Event Cycle
Hi,
I have asp button as follow: