Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    CA
    Posts
    38

    Unanswered: tablespace not resizing

    Hi,
    I have created a tablespace and when I try to resize it I get this error message...

    SQL> alter database dba2 datafile
    2 '/opt/Oracle8i/u03/dba2/DATA/DISK5/data02.dbf'
    3 resize 1500k;
    alter database dba2 datafile
    *
    ERROR at line 1:
    ORA-03296: cannot resize datafile - file
    /opt/Oracle8i/u03/dba2/DATA/DISK5/data02.dbf not found

    while if I select tablespace_name,file_name,bytes from dba_data_files it shows me the data and also when I tried to look it up on the drive it shows me this
    -rw-r----- 1 oracle csci379 1052672 Oct 1 17:44 data02.dbf?

    i dunno why is there a question mark...well, also am not much conversant with Linux...so if this means sth...
    can u plz figure out what is the exact problem or will I have to drop the tablespace 'n add it again???
    Thank you.
    Pooja

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    Please post the output from the select statement that you ran against the dba_data_files view and a long listing from the directory where the data file is located. It looks like someone made a typo when they were creating the data file.

  3. #3
    Join Date
    Sep 2003
    Location
    CA
    Posts
    38
    Here it is,

    SQL>select file_name,tablespace_name from dba_data_files;
    FILE_NAME TABLESPACE
    -------------------------------------------------- ----------
    /opt/Oracle8i/u03/dba2/DATA/DISK4/data01.dbf DATA01
    /opt/Oracle8i/u03/dba2/DATA/DISK5/data02.dbf DATA02
    /opt/Oracle8i/u03/dba2/DATA/DISK6/indx01.dbf INDX01
    /opt/Oracle8i/u03/dba2/DATA/DISK1/system01.dbf SYSTEM
    /opt/Oracle8i/u03/dba2/DATA/DISK2/rbs01.dbf RBS
    /opt/Oracle8i/u03/dba2/DATA/DISK3/data01.dbf DATA
    /opt/Oracle8i/u03/dba2/DATA/DISK2/temp01.dbf TEMP
    /opt/Oracle8i/u03/dba2/DATA/DISK2/indx01.dbf INDX
    /opt/Oracle8i/u03/dba2/DATA/DISK3/oemrep01.dbf OEM
    /opt/Oracle8i/u03/dba2/DATA/DISK1/query01.dbf QUERY_DATA

    10 rows selected.

    bash-2.05$ cd /opt/Oracle8i/u03/dba2/DATA/DISK5
    bash-2.05$ ls -l
    total 8640
    -rw-r----- 1 oracle csci379 700416 Sep 30 12:49 control01.con
    -rw-rw---- 1 pooja s 700416 Sep 30 12:49 control02.con
    -rw-r----- 1 oracle csci379 1052672 Oct 1 19:45 data02.dbf?
    -rw-r----- 1 pooja s 2097664 Sep 23 12:08 redo0103.log
    -rw-r----- 1 pooja s 2097664 Sep 23 12:10 redo0203.log
    -rw-r----- 1 oracle csci379 1049088 Oct 1 19:45 redo0303.log
    -rw-r----- 1 oracle csci379 1049088 Oct 2 10:31 redo0403.log

    is that enuf?thanx for helpin'.
    Pooja



    Originally posted by bandersonclow
    Please post the output from the select statement that you ran against the dba_data_files view and a long listing from the directory where the data file is located. It looks like someone made a typo when they were creating the data file.

  4. #4
    Join Date
    Oct 2003
    Posts
    2
    Does this tablespace contain crucial data? If it doesn't contain any data, then I would try the same statement that you did at first, but add the ? onto the end of the data file name and see if it then resizes. If it then resizes, you could then do a rename on the data file and correct the ? mark problem at the end of the file name. If the tablespace contains crucial data, then I'd create a new tablespace and migrate the data to that tablespace. Let me know how things go and if you need any help with command syntax.

    Brian

  5. #5
    Join Date
    Sep 2003
    Location
    CA
    Posts
    38
    Hi Brian,
    well, actually i tried appending the ? but that didn't quiet help...it still says the same....it doesn't contain any data 'coz i had jus' created it...so I jus' dropped it 'n created a new one but I jus' don't understand what could that mean...'coz its kinda peculiar seeing a ? next to a filename....I had created another tablespace which had the same notation i.e. on disk the file name displays a ? next to it....
    neways, if u get to know anything why it would be so plz do tell me.
    Thank you for helpin' me.
    Keep the faith,
    Pooja

    Originally posted by bandersonclow
    Does this tablespace contain crucial data? If it doesn't contain any data, then I would try the same statement that you did at first, but add the ? onto the end of the data file name and see if it then resizes. If it then resizes, you could then do a rename on the data file and correct the ? mark problem at the end of the file name. If the tablespace contains crucial data, then I'd create a new tablespace and migrate the data to that tablespace. Let me know how things go and if you need any help with command syntax.

    Brian

Posting Permissions

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