[comp.databases] Need help with ORACLE ALTER TABLE ADD DATAFILE

beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) (11/08/90)

  I am trying to create an index on a table, "lshift" that has 27,000
  rows. Adding up the # and sizes of the extents allocated for it I
  guess that it takes up between 500 and 800 KB. (the table that is)

  When I try to create the index it fails and I get the msg

  ORA-01547: failed to allocate extent of size 62 in Tablespace SYSTEM.

  WHAT units is this 62 in? THe last extent allocated for the table
  lshifts was 286,720 bytes, and the PCT increase is 50.
  Is the failed extent part of some temporary table rather than Lshift?

  How big a file do I need to add using ALTER TABLESPACE?
  I seem to be able to add files alright, but is there a preferred place
  where I should put them? 
  .