How do I create a new datafile for extension of a tablespace?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How do I create a new datafile for extension of a tablespace?

  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Question

    I want to add a new datafile to one of my user tablespaces. ALTER TABLESPACE xyz ADD DATAFILE requires an existing datafile. But how the heck do I create such a new empty datafile??

    (I am running Oracle 8.1.5 Personal Edition on Win98.)

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    alter tablespace xyz add datafile 'W:\ORACLE\NT815\XYZ02.dbf'
    size 1024M autoextend on next 1024M maxsize 20480M;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2002
    Posts
    3
    hi ,
    to create a new datafile

    Create tablespace datafile ‘f:/oracle/.dbf’ size 100M extent management local autoextend on 10M;

    i think this will help u,

    regards,
    Ramesh

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