1 Reply Latest reply on Sep 18, 2012 5:42 AM by Vishal Joshi

    create and drop db links

      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.