Database Administration (MOSC)

MOSC Banner

Question of datafiles on QFS file systems and inode limitations

edited Jun 22, 2010 9:41AM in Database Administration (MOSC) 7 commentsAnswered ✓
I was wondering if anyone could answer a question for me?

We have our datafiles on a SUN QFS on one mounted drive. The drive was being used to explode some tar files in order to use them for import into the database. Unfortunately in QFS there is a limitation of the number of inodes available and there were so many small files in the tar files we hit these limits. As a result, the files were untarred into another directory and links were created. However, while trying to increase a datafile size, I ran into the following error:

ORA-01237: Cannot extend datafile xx

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center