Datafile manipulation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Datafile manipulation

  1. #1
    Join Date
    Mar 2003
    Posts
    38

    Datafile manipulation

    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.
    __________________________________
    PVKDBA

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Post the commands and messages...
    Last edited by Thomasps; 08-14-2006 at 08:24 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Quote Originally Posted by 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.
    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.
    this space intentionally left blank

  4. #4
    Join Date
    Mar 2003
    Posts
    38
    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.
    __________________________________
    PVKDBA

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    If you created your index as global partition, I think you don't need to specify update global indexes.
    ---------------

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    global index => need rebuild
    local => index not needed

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

  7. #7
    Join Date
    Mar 2003
    Posts
    38

    .nfs filename prefix

    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

  8. #8
    Join Date
    Mar 2003
    Posts
    38
    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.
    __________________________________
    PVKDBA

  9. #9
    Join Date
    Jul 2006
    Posts
    2
    Quote Originally Posted by 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



    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.

  10. #10
    Join Date
    Mar 2003
    Posts
    38
    Thanks to all. Its just got through with the existing problem
    __________________________________
    PVKDBA

Posting Permissions

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



Click Here to Expand Forum to Full Width