Creating a Tablespace Remotely - Page 2 Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Creating a Tablespace Remotely

  1. #11
    Join Date
    Feb 2003
    I'm definitely sure you're putting the path wrong.
    Please check that your mentioned path exists.

  2. #12
    Join Date
    Jun 2005
    London, UK
    Quote Originally Posted by dre1988

    i'm connected to the DB server via SQLPlus from my desktop. i've got a tnsnames entry for the DB and the system login to it. that's it. i have no operating system account for the server at this point or an OEM login to its management server instance. this is the error:

    ERROR at line 1:
    ORA-01119: error in creating database file '/path_on _server/file.dbf'
    ORA-27040: skgfrcre: create error, unable to create file
    SVR4 Error: 2: No such file or directory
    Just to be clear, SQL commands you enter from any client application, whether it is SQL*Plus, OEM, TOAD or anything else, are executed on your behalf by the database server. When you enter a CREATE TABLESPACE command and specify a path, a process owned by oracle (not you) will look on the server and attempt to create the file.

  3. #13
    Join Date
    Jul 2005
    hi dre1988
    run a query on sql as

    SQL > select FILE_NAME, TABLESPACE_NAME from dba_data_files;

    you will get the location where current data files are use the same path to create ur tablespace , job done .


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width