Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dbrs4me

    SQL Left Outer Join question

    I started by needing a query that pulled all the orders created for a given time frame and then needing to see what orders have been sent during that same time period. There are times when the order has been created, but not sent. Here is the table structure: ORDER ID ORDERNUM DATE_CREATED...
  2. dbrs4me

    Book Search - Oracle OWB and OBIEE

    Hello everyone, thanks for taking the time to read this. I am new in the DBA role having promoted into it internally. Part of what I inherited is a complete OWB system that feeds into OBIEE. We are on a tight budget at the moment and I have been told that I won't be able to take any formal...
  3. dbrs4me

    NLS_CharacterSet update and Standby Databases

    Thank you for replying to this thread. I was on a time crunch of sorts and had to plow away with this conversion on the primary database. I ended up deleting both standby's and recreating them. The character set change carried through to the standby creation. It was pretty transparent. Thanks again
  4. dbrs4me

    NLS_CharacterSet update and Standby Databases

    We have a bunch of databases that use the WE8ISO8859P1 character set. We needed to add the EURO symbol to our Currency setup, but that character isn't supported. The simple solution is to migrate to the WE8MSWIN1252 character set. Oracle has lots of documentation about this and I was able to...
  5. dbrs4me

    Time Zone collaboration between Windows and Oracle

    Hello, I am getting this message when I try to run an application that communicates to an 11gR1 database, "Your time zone GMT Daylight Time could not be located in the Oracle Time Zone list. Your local date and time will be used for all changes to the database. Processes will now continue...
  6. dbrs4me

    New User can't see Tables in SQL Developer

    I found the solution that I was looking for on this. If you have select access to another user's tables in their schema and you want to be able to see them in the Tables drop-down in SQL Developer, connect to the SID in SQL Developer. In the pane on the left side scroll down to Other Users and...
  7. dbrs4me

    New User can't see Tables in SQL Developer

    Frederico said: How does the user select the correct schema within SQL Developer?
  8. dbrs4me

    New User can't see Tables in SQL Developer

    I need guidance on how to effect those GRANTs, please.
  9. dbrs4me

    New User can't see Tables in SQL Developer

    Thanks Santa, you are correct, it is the schema name before the table. Also, the plus sign in front of the Tables that I mentioned in SQL Dev is to open the tables in a folder like view. When you are the schema owner you can see all the tables, when you aren't, you can't. Any ideas on how to...
  10. dbrs4me

    New User can't see Tables in SQL Developer

    ...it comes back empty. The user is able to see the contents of the table with a select statement as long as it is prefixed by the TABLESPACE name, i.e. SELECT * FROM DM.table I am sure I am missing something simple, a grant statement more than likely. Can someone help me out please. Much Thanks
  11. dbrs4me

    How to update one field with data from a different field, same record

    That is exactly what I wanted. Thank You!
  12. dbrs4me

    How to update one field with data from a different field, same record

    I need a script to update a field that holds a directory path, WORK_PATH. Right now this field holds a lot of 'F:\' and some longer UNC paths '\\server\dir\dir\username'. I need to update this field with a different UNC path, but I need that last value of the UNC path to be the USERID field from...
  13. dbrs4me

    Performance Monitoring

    My CIO has tasked me with creating my own set of performance metrics. He basically wants me to create a stop light type of metric where green means the database is running fine, yellow means the database is still running, but it is under some stress and red means the database is very very busy...
  14. dbrs4me

    Max Performance

    Also, is there a service I should turn off until the issue is resolved?
  15. dbrs4me

    Max Performance

    We are doing a network upgrade and had to bring down a remote data center. Our physical standby, in Max Performance mode, didn't come back up due to a hardware failure. It could be anywhere from a couple hours to a couple days before we are able to bring it online. I believe at that point the...
  16. dbrs4me

    Left Outer Join not giving me desired results

    Thargy, I was able to create the tables using your script. It responds the way I stated above. Dagon, There is always at least one match between main and submain so this isn't an issue. I think if it were missing from submain I would just get a null value.
  17. dbrs4me

    Left Outer Join not giving me desired results

    Hello, I am trying to create a view, but to do that you need good SQL code. I am looking at two tables, I have represented them below. The current set of code works, but not the way I need it to. See the code and the Actual vs. Desired results. Select Main.id, Main.Sub_ID, SM1.parent_id...
  18. dbrs4me

    Alter Table... Move

    Thank you Santa, It looks like the tablespace is locally managed already. With that in mind, do I need alter the table or is that unnecessary? Charlie
  19. dbrs4me

    Alter Table... Move

    Hello, I have a table that has grown, as they do. Over time it has had to create extents for itself. The following SQL: SELECT SEGMENT_NAME,TABLESPACE_NAME,EXTENTS,BLOCKS FROM DBA_SEGMENTS where segment_name = 'table-name'; tells me that the table has had to extend itself 260 times. I think...
  20. dbrs4me

    Retention Policy

    ...= `hostname` prompt date = `date` prompt ORACLE_HOME = $ORACLE_HOME prompt ORACLE_SID = $ORACLE_SID show sga select * from v\$version ; select * from v\$instance ; select * from v\$database ; select * from dba_tablespaces order by 1 ; select * from...

Part and Inventory Search

Back
Top