Datafile Extend - 03296 error [message #54702] |
Fri, 29 November 2002 04:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Simon
Messages: 60 Registered: December 1998
|
Member |
|
|
When trying to extend a datafile I get an 03296 error saying file name unknown. This datafile and tablespace is known by system and can be seen in relevant views. If I backup to control file the datafiel can also be seen. We can extend other files so system has enough space. There is also enough space on the UNIX o/s. Any clues please. I'm especially concerned that if we bounce Oracle it may not recognice the file and therefore not come up. We've missed some backups recently so we dont want to have to do any type of restore...thanks
|
|
|
Datafile Extend - 03296 error [message #54704 is a reply to message #54702] |
Fri, 29 November 2002 07:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Simon
Messages: 60 Registered: December 1998
|
Member |
|
|
Found answer thanks. The file had a space at the end when it was created so if you query it in v$datafiles with like it finds it but if you use the full path name without the space or %'s it didn't.
|
|
|