10 Replies Latest reply on Dec 18, 2008 1:51 AM by user346369

    Old posts...missing?

    438410
      I am looking for an old thread I created before the forums were upgraded, because I've run into the same problem again and want to see what the answer was. When I go to my control panel, I don't see any posts from before the forum upgrade...are they long lost?
        • 1. Re: Old posts...missing?
          Maran Viswarayar
          They are not lost...since you dont have the search option with a particular username you shouldbe able search with right keywords there

          I have founf my prvious posts
          • 2. Re: Old posts...missing?
            649606
            but searching by keywords will just give you back results that will stirrup your peaceful mind instead of giving you the exact solution found in your own previous post :((
            • 3. Re: Old posts...missing?
              Jonathan Lewis
              Some things have definitely disappeared.

              I keep a watch list, and choose the option to keep indefinitely, on the threads that contain any particularly useful material. The list looked a lot shorter after the upgrade.

              Here's an example of a thread that contained a number of useful posts that I can no longer find.

              http://forums.oracle.com/forums/thread.jspa?threadID=663687&tstart=0

              Regards
              Jonathan Lewis
              http://jonathanlewis.wordpress.com
              http://www.jlcomp.demon.co.uk

              "The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge." Stephen Hawking.
              • 4. Re: Old posts...missing?
                justinkestelyn
                Certain extremely long messages (40K+ chars) have been identified as a source of performance issues; they have been moved to a private area for that reason.
                • 5. Re: Old posts...missing?
                  Jonathan Lewis
                  jkestely wrote:
                  Certain extremely long messages (40K+ chars) have been identified as a source of performance issues; they have been moved to a private area for that reason.
                  Thanks for that information.
                  Is it safe to assume that they weill reappear at some time in the future.


                  Regards
                  Jonathan Lewis
                  http://jonathanlewis.wordpress.com
                  http://www.jlcomp.demon.co.uk

                  "The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge." Stephen Hawking.
                  • 6. Re: Old posts...missing?
                    Jonathan Lewis
                    jkestely wrote:
                    Certain extremely long messages (40K+ chars) have been identified as a source of performance issues; they have been moved to a private area for that reason.
                    It's been a couple of months since these posts were moved out of the general forum - is there any indication of when they will return ?

                    In the interim, I have a version of the thread I mentioned above saved in a Word document; would there be any issue with me posting it to my blog ? I had a posting on my blog that highlighted three or four useful dialogues running through the thread, and it's irritating that the thread can't be reached.


                    Regards
                    Jonathan Lewis
                    http://jonathanlewis.wordpress.com
                    http://www.jlcomp.demon.co.uk

                    "Science is more than a body of knowledge; it is a way of thinking" Carl Sagan
                    • 7. Re: Old posts...missing?
                      247514
                      Not sure why long message over 40k chars is treat to performance. is it because fulltext index?
                      I found even the thread list page of General forum is slower than some other forums. I have to limit my posts per page to 25 down from 50. That helps a bit.
                      • 8. Re: Old posts...missing?
                        user346369
                        jkestelyn wrote:
                        Certain extremely long messages (40K+ chars) have been identified as a source of performance issues; they have been moved to a private area for that reason.
                        I would sure like to know what happened to this thread:  Doubt in dynamic Sql

                        I have written a number of posts linking to it since I had posted some very useful and unique code.  And now it is gone.     ...any chance of getting it back?

                        I am sure the post was not over 40K.  I just don't write that much! In fact, the Forms 10g installed and running on Windows Vista I have ever written is only about 17K.
                        • 9. Re: Old posts...missing?
                          justinkestelyn
                          Am I missing something? I see the thread behind your embedded URL.
                          • 10. Re: Old posts...missing?
                            user346369
                            jkestelyn wrote:
                            Am I missing something? I see the thread behind your embedded URL.
                            Well I thought it would be obvious -- the second post is a thanks to someone named steve, posted six months after the first one. ...and since I posted above, where did the third post go, a "thanks" in large red font? Good grief!

                            Trust me, I had posted some useful Exec_SQL coding examples there.  I was hoping to use it again as a reference for a recent post, and all I can find is the pointers to two nonexistent posts:

                            http://forums.oracle.com/forums/thread.jspa?messageID=1100901#1100901
                            http://forums.oracle.com/forums/thread.jspa?messageID=1127546#1127546

                            For example, see these posts:
                            Dec 23, 2007:   Re: Signature of Package SYS.DBMS_SQL
                            Jan 12, 2007:   Re: When-new-form-Instance trigger raised unhandled exception ORA-04062
                            Mar 4, 2008:    Re: ORA-306500 error when using EXEC_SQL?