User Profile

Collapse

Profile Sidebar

Collapse
arg
arg
Last Activity: Dec 8 '06, 06:40 PM
Joined: Oct 6 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • arg
    replied to Simple Select Qry
    in Oracle
    I know this is rather late, but this can be done with out views etc.
    Check out http://www.oracle.com/technology/oramag/code/tips2005/062005.html

    I do not see a way to dynamicaly create column titles from rows without multiple views, functions, or procedures.
    See more | Go to post

      Leave a comment:

    • arg
      replied to Timezone Conversions - URGENT
      in Oracle
      I think NEW_TIME is the function you are looking for. Which version of oracle?
      http://www.stanford.ed u/dept/itss/docs/oracle/10g/server.101/b10749/ch4datetime.htm...
      See more | Go to post

        Leave a comment:

      • arg
        replied to One service missing: OracleHome81TNSListener
        in Oracle
        Do you have any thing else labeled Listener? Or remember what you called the listener when you installed the database? lsnrctl will tell if the listener is running and what databases are local. You also have to know what port the listener was installed on.

        On a windows oracle system you can use the 'Oracle Database Configuration Assistant' wizard to create additional listeners.
        See more | Go to post

          Leave a comment:

        • arg
          replied to E Mail Using PL/SQL Procedure
          in Oracle
          There are links all over the web for this. You need to have run specific scripts in <oracle home>/rdbms/admin.

          Here are some example web links
          http://www.oracle-base.com/articles/9i/EmailFromPLSQL9 i.php

          http://www.psoug.org/reference/utl_smtp.html

          http://asktom.oracle.c om/pls/ask/f?p=4950:8::::: F4950_P8_DISPLA YID:25561516080 5

          http://www.faqs.org/rfcs/rfc821.html
          ...
          See more | Go to post

            Leave a comment:

          • arg
            replied to Copy data to another schema
            in Oracle
            I bet TOAD is waiting on a constraint, trigger or a lock, neither will return an error message to toad. A update/insert trigger set on a table or it's index your copying is most likely your problem. Using 'Create like' or 'Create script' or 'Create in another schema'?
            See more | Go to post

              Leave a comment:

            • arg
              replied to internal error code: core dump
              in Oracle
              Solaris? fix:
              Increase the unix kernel parameter SEMMNS to a higher value. This will allow
              the database to started with a higher processes parameter.

              New database?
              Perhaps lingering oracle instance with same SID out there?
              See more | Go to post

                Leave a comment:

              • arg
                replied to BLOB from Oracle
                in Oracle
                Why flush before the close? What happens if you don't?
                C# right? http://msdn2.microsoft .com/en-us/library/36b93480.aspx
                See more | Go to post

                  Leave a comment:

                • arg
                  replied to How to debug a Store Proc in Oracle using TOAD
                  in Oracle
                  Toad has a seperate DEBUG module that cost extra. Other than that you have to use DBMS OUTPUT or something.
                  See more | Go to post

                    Leave a comment:

                  • arg
                    replied to Oracle 9i on windows 2003 server
                    in Oracle
                    What kinda databases are we talking about here? OLTP, Data warehouses?
                    High avaibility requirements? RAC? storage? One of the bigest issues with Win2003 is the 2-4GB memory settings. Multi proc dual core systems?
                    See more | Go to post

                      Leave a comment:

                    • arg
                      replied to internal error code: core dump
                      in Oracle
                      Ah this is a ORA-600 error. and I dont have metalink access at the moment. If you have a metalink account, and you should! look for the ORA 600 error message lookup tool.
                      See more | Go to post

                        Leave a comment:

                      • arg
                        replied to Retrive Sys Pwd
                        in Oracle
                        You can't. At least Oracle says you can't.

                        I would either "connect / as sysdba"
                        then "alter user sys identified by new_pass"
                        or
                        use a external application ORAPWD, ORADIM to recreate the password. These are usually located in <OrACLE Home>/bin

                        odds are the password is 'manager'. lol
                        See more | Go to post

                          Leave a comment:

                        No activity results to display
                        Show More
                        Working...