Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
E-Business Suite Technology
EBS on Linux
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Sep 18, 2012 12:42 AM by
create and drop db links
Sep 11, 2012 5:44 AM
can anyone tel me how to create a file where i can store the statements like
create database link xxxx connect to apps identified by apps using'host';
when i try to save it to a file saying vi create.sql its not allowing me to save. its not allowing me to save it...im getting the error like
"createlink.sql" E212: Can't open file for writing
Press ENTER or type command to continue
can anyone tell me how to save it and when done RMAN cloning i use this to remove the source data and place the old db links.
thanks in advance.
This content has been marked as final.
Show 1 reply
Re: create and drop db links
Sep 18, 2012 12:42 AM
in response to
it seems like you are facing permission issue where you are trying to save the file. Kindly check if your user is having permission to write where you are saving file? if it is not then try some other location.