Datafile manipulation

[pvkdba]

I do have small clarification, perhaps very minure, needs clarification.

While I do enlarging the size of the datafile do I need to take it OFFLINE,

Because, I have done with ONLINE, so it says unable to increase / Decrease,

So was the case with OFFLINE too.

In both the cases I could do any manipulation on the existing datafile.

Thanks.

[Thomasps]

Post the commands and messages...

[gandolf989]

I do have small clarification, perhaps very minure, needs clarification.

While I do enlarging the size of the datafile do I need to take it OFFLINE,

Because, I have done with ONLINE, so it says unable to increase / Decrease,

So was the case with OFFLINE too.

In both the cases I could do any manipulation on the existing datafile.

Thanks.

If the disk volume is nearly full then you would not be able to expand the datafile by much. And if the high water mark is near the end of the datafile then you may not be able to shrink it much either.

You should not need to take a data file offline to shrink or expand it.

[pvkdba]

Thanks for the replies so far.

I have a scenario like this:

I have to drop the partition which is Range partition,

Alter tables drop partition update global indexes;

In the above statement do I need to really add the (Suffix) UPDATE GLOBAL INDEXES?

The problem is I do have large data on the pratitioned table and if I add the suffix then my question is :

After performing the DROP partition scenario, Do I need to DROP and RECREATE the Indexes which are based on the partitions OR else need to do REBUILD the index based partitions?


Thanks in advance.

[reydp]

If you created your index as global partition, I think you don't need to specify update global indexes.

[pando]

global index => need rebuild
local => index not needed

your question is about datafiles, how come you are asking about indexes now?!

[pvkdba]

Hi Experts,

I have a partition problem for which I am backing up the datafiles, during the process the datafiles have been corrupted and I could able to refix the problem, but the crux of the problem is what is this nfs prefix file names?


I am just pasting the output from the filesystem, can anyone define this?

prim@dbsrv001> ls -al
total 293476714
drwxrwxr-x 3 oracle dba 4096 Aug 16 13:40 .
drwxr-xr-x 7 oracle dba 512 Sep 16 2005 ..
-rw-r----- 1 oracle dba 33554440192 Aug 16 12:11 .nfs0A35
-rw-r----- 1 oracle dba 6291464192 Aug 16 12:11 .nfs1A35
-rw-r----- 1 oracle dba 34359730176 Aug 16 12:11 .nfs2A35
-rw-r----- 1 oracle dba 17825800192 Aug 16 12:11 .nfs3A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs4A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs5A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs6A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs7A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs8A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs9A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfsAA35
-rw-r----- 1 oracle dba 3145736192 Aug 16 12:11 .nfsB935
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfsBA35
-rw-r----- 1 oracle dba 1153441792 Aug 16 12:11 .nfsC935
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfsCA35
-rw-r----- 1 oracle dba 1153441792 Aug 16 12:11 .nfsD935
-rw-r----- 1 oracle dba 31404859392 Aug 16 12:11 .nfsDA35
-rw-r----- 1 oracle dba 1153441792 Aug 16 12:11 .nfsE935
-rw-r----- 1 oracle dba 1048584192 Aug 16 13:16 .nfsF935
drwxrwxrwx 11 root root 4096 Aug 16 08:00 .snapshot

Thanks

[pvkdba]

Hi,

Giving the explanation for why I am giving the problem for datafile to partition and index is what I have done in the above example.

The process consists of datafile, partition as well as indexes now the nfs prefix.

Thanks for your invaluable answers which are worked out.

[PDSET]

Hi Experts,

I have a partition problem for which I am backing up the datafiles, during the process the datafiles have been corrupted and I could able to refix the problem, but the crux of the problem is what is this nfs prefix file names?


I am just pasting the output from the filesystem, can anyone define this?

prim@dbsrv001> ls -al
total 293476714
drwxrwxr-x 3 oracle dba 4096 Aug 16 13:40 .
drwxr-xr-x 7 oracle dba 512 Sep 16 2005 ..
-rw-r----- 1 oracle dba 33554440192 Aug 16 12:11 .nfs0A35
-rw-r----- 1 oracle dba 6291464192 Aug 16 12:11 .nfs1A35
-rw-r----- 1 oracle dba 34359730176 Aug 16 12:11 .nfs2A35
-rw-r----- 1 oracle dba 17825800192 Aug 16 12:11 .nfs3A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs4A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs5A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs6A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs7A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs8A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfs9A35
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfsAA35
-rw-r----- 1 oracle dba 3145736192 Aug 16 12:11 .nfsB935
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfsBA35
-rw-r----- 1 oracle dba 1153441792 Aug 16 12:11 .nfsC935
-rw-r----- 1 oracle dba 2097160192 Aug 16 12:11 .nfsCA35
-rw-r----- 1 oracle dba 1153441792 Aug 16 12:11 .nfsD935
-rw-r----- 1 oracle dba 31404859392 Aug 16 12:11 .nfsDA35
-rw-r----- 1 oracle dba 1153441792 Aug 16 12:11 .nfsE935
-rw-r----- 1 oracle dba 1048584192 Aug 16 13:16 .nfsF935
drwxrwxrwx 11 root root 4096 Aug 16 08:00 .snapshot

Thanks

This is something to do with the NFS file system in the Unix OS as if the application closes with corruption then it will fix the .nfsXXXXX with the file is being actually in accessible but corrupted. The simple way to do is deleting the files of this nature and still if you comeback without affecting the filesystem then it will simply revert the file back to you or else its near disaster. In that event you must recover from the filesystem.

Hope this will be sufficient to deal with the .nfsXXXX file structure.

[pvkdba]

Thanks to all. Its just got through with the existing problem