Update ... order by .. error :PLS-00103 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Update ... order by .. error :PLS-00103

  1. #11
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Re: Re: Thank you alll.....

    Originally posted by chrisrlong
    Everytable needs a PK.
    To every rule there is an exception, and here it is -- it is generally accepted that large data warehouse fact tables do not need a PK, mostly because

    i) you can rely on rowid for unique identification, and
    ii) you will not need to reference the table through a foreign key.

    I expect that is not the case here however, so I'm just being pedantic.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #12
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339

    Re: Re: Re: Thank you alll.....

    Originally posted by slimdave
    I expect that is not the case here however, so I'm just being pedantic.
    Well.... quit it
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

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