Results 1 to 5 of 5

Thread: Fragmentation

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Unanswered: Fragmentation

    HI,

    THIS IS ABOUT A VERTICAL FRAGMENTATION OF SOME TABLES THAT I HAVE IN ORACLE 8i.

    HOW TO DIVIDE A TABLE IN VERTICAL FRAGMENTS IN ORACLE (SQL SENTENCES).

    THANKS.

    I NEED TO KNOW EVERYTHING ABOUT FRAGMENTATION SQL SENTENCES.

    THANKS !!!!

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Jortiz,

    I'm not sure I fully understand the question, but I am sure your English is 100 times better than my foreign language (vielleicht außer Deutsch)skills :-)

    Do you mean partitioning (storing parts of a table in different storage 'areas') or getting smaller recordsets from a table?

    Cheers
    Bill

  3. #3
    Join Date
    Jun 2003
    Posts
    294
    Thank´s !!

    Well, I mean, I have something like this:

    A common table with many rows in it:

    ***********
    * CLIENT *
    ***********
    *ID *
    *ADDRESS *
    *P_NUMBER*
    *AGE *
    *..... *
    ***********

    And I wanna Have something like this:

    ***********
    *CLIENT_VI*
    ***********
    *ID *
    *ADDRESS *
    ***********

    ***********
    *CLIENT_DA*
    ***********
    *ID *
    *P_NUMBER*
    *AGE *
    *..... *
    ***********

    WHAT DO I HAVE TO DO?

    pd. Vertical fragmentation divides a relation “vertically” by columns

    I have to get vertical fragments and do replication.


    Bye ! Thank's

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    We'd call that vertical partitioning. What you have to do is simply create the required tables like this:

    SQL> create table client_vi as select id, address from client;

    SQL> create table client_da as select id, p_number, age, ... from client;

    Then add primary keys (id) on each table, make one the master and create foreign keys from the others to the master.
    Finally, drop the original table.

    You could also create a view that looks like the original table, if wanted:

    SQL> create view client as select v.id, v.address, d.p_number, d.age, ...
    from client_vi v, client_da d
    where v.id = d.id;

    Is that what you meant? Not sure what it has to do with replication, though.

  5. #5
    Join Date
    Jun 2003
    Posts
    294

    Yes, Sure

    Thank's so much man !!!

    That's it ! what you said is correct !


    When I say replication, is to send the rows that was in the old table, to the new tables.

Posting Permissions

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