+ Reply to Thread
Results 1 to 5 of 5

dump dir for export

  1. dump dir for export

    hi,

    i create and grant directory for export db:

    CREATE DIRECTORY dump_dir AS 'D:\data';

    but if i want to change dump_dir value directory??

    CREATE DIRECTORY dump_dir AS 'F:\datadump';

    it show me error ORA-00955, how can i change dump_dir value??

    thanks!


  2. Re: dump dir for export

    Andrea wrote:

    > i create and grant directory for export db:
    >
    > CREATE DIRECTORY dump_dir AS 'D:\data';
    >
    > but if i want to change dump_dir value directory??
    >
    > CREATE DIRECTORY dump_dir AS 'F:\datadump';
    >
    > it show me error ORA-00955, how can i change dump_dir value??


    CREATE OR REPLACE DIRECTORY dump_dir AS 'F:\datadump';

    --
    Cris Carampa (spamto:cris119@operamail.com)

    All foreign wars I do proclaim
    Live on blood and a mother's pain



  3. Re: dump dir for export

    Andrea wrote:

    > i create and grant directory for export db:
    >
    > CREATE DIRECTORY dump_dir AS 'D:\data';
    >
    > but if i want to change dump_dir value directory??
    >
    > CREATE DIRECTORY dump_dir AS 'F:\datadump';
    >
    > it show me error ORA-00955, how can i change dump_dir value??


    CREATE OR REPLACE DIRECTORY dump_dir AS 'F:\datadump';

    --
    Cris Carampa (spamto:cris119@operamail.com)

    All foreign wars I do proclaim
    Live on blood and a mother's pain



  4. Re: dump dir for export


    Cris Carampa ha scritto:

    > Andrea wrote:
    >
    > > i create and grant directory for export db:
    > >
    > > CREATE DIRECTORY dump_dir AS 'D:\data';
    > >
    > > but if i want to change dump_dir value directory??
    > >
    > > CREATE DIRECTORY dump_dir AS 'F:\datadump';
    > >
    > > it show me error ORA-00955, how can i change dump_dir value??

    >
    > CREATE OR REPLACE DIRECTORY dump_dir AS 'F:\datadump';



    thanks!


  5. Re: dump dir for export


    Cris Carampa ha scritto:

    > Andrea wrote:
    >
    > > i create and grant directory for export db:
    > >
    > > CREATE DIRECTORY dump_dir AS 'D:\data';
    > >
    > > but if i want to change dump_dir value directory??
    > >
    > > CREATE DIRECTORY dump_dir AS 'F:\datadump';
    > >
    > > it show me error ORA-00955, how can i change dump_dir value??

    >
    > CREATE OR REPLACE DIRECTORY dump_dir AS 'F:\datadump';



    thanks!


+ Reply to Thread