Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    8

    Unanswered: Sybase features???

    Hi,

    I used to work on Oracle and am new to Sybase. It looks like Sybase has fewer features than Oracle and I have a few questions regarding to Sybase ASE11.9 and ASE12:

    1. With Oracle, I can use database link and tnsname to set up the distributed environment so that I can access data located in unix boxA from Unix boxB. Does Sybase ASE providing the similar feature? If so, what steps need to be performed?

    2. Oracle provide partition feature since version 8, how about Sybase? Can I partition a table by column with Sybase ASE? I read some documents and it sound like Sybase partition concept is different to Oracle.

    3. Any recommended web-site for sybase DBA so that I can easily find out syntax, concept, definition, etc? Might be I am new to Sybase, I found that Sybase online manual is not as friendly as Oracle.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: Sybase features???

    1. Use CIS (Component Integration System), remote servers & proxy db/table to do the same. Available since ASE 11.5


    2. Partition available since ASE 11.0.3. Easy to apply, really usefull with the parallelism

    3. Is it humoristic ? Sybboks is easier to use than Oracle tech. Check http://sybooks.sybase.com/asg1250e.html and compare with http://otn.oracle.com/documentation/database10g.html ;-)
    Last edited by fadace; 02-25-04 at 08:27.

  3. #3
    Join Date
    Feb 2004
    Posts
    8

    Unhappy

    Fadace,

    Thanks for the feedback.

    1. Any detail information and detail steps

    2. I want to know if Sybase can perform partition based on let say by month or by quarter?

    3.humoristic ? Did you not see my struggling face?

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    1. http://sybooks.sybase.com/onlinebook...8594;lang=fr#X

    2. Alter the table to partition, then create a clustered index in your date fields. This cluster index will dispatch the data in the partitions. FYI: ordering the data by date will decrease perf, because only some partitions will be used in a specific time. To historize, prefer the use of several tables + view with unions in these tables

    3. ;-)

  5. #5
    Join Date
    Feb 2004
    Posts
    8
    There was a previous discussion for the features of Sybase against Oracle
    http://dbforums.com/arch/56/2003/8/861517

Posting Permissions

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