DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Creating a Tablespace Remotely

  1. #1
    Join Date
    Nov 2002
    Posts
    30

    Creating a Tablespace Remotely

    version: Oracle 9.2

    i need to create a tablespace whose datafile resides on the database server. however, i can only access the database remotely via sql*plus (no OEM login). is there a way to create the tablespace like this even though the path to the datafile applies only to the server?

    example:
    CREATE TABLESPACE ESB_GRANITE_CTS_DATA
    DATAFILE
    '/path_on_server' SIZE 200M
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    SEGMENT SPACE MANAGEMENT AUTO;

    thanks!

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You can.
    I don't see any problem.

    Tamil

  3. #3
    Join Date
    Nov 2002
    Posts
    30
    how is it done? i'm trying to run this script from my desktop. how do you let oracle know that the path to the .dbf file is on the server?

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You've already logged into the database server to execute the command, right? Are you getting an error or something?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Nov 2002
    Posts
    30
    Quote Originally Posted by slimdave
    You've already logged into the database server to execute the command, right? Are you getting an error or something?
    slimD,

    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

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    is that spave in the name deliberate ora typo?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Nov 2002
    Posts
    30
    it's deliberate to protect the innocent.

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    so does that path exist? does the oracle user have permission to create a file there?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Nov 2002
    Posts
    30
    the path exists but the file does not. the oracle user is system. i am not sure if system is set up on the server with permission to create files in the path.

  10. #10
    Join Date
    Mar 2002
    Posts
    534
    Quote Originally Posted by dre1988
    i am not sure if system is set up on the server with permission to create files in the path.
    when do you plan to check it?

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