This discussion is archived
1 Reply Latest reply: Sep 17, 2012 10:42 PM by 736073 RSS

create and drop db links

961329 Newbie
Currently Being Moderated
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"
"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.
  • 1. Re: create and drop db links
    736073 Explorer
    Currently Being Moderated
    Hi,

    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.

    Thanks,
    Vishal Joshi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points