Search results for query: *

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...

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...

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...

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...

I created a user that needs read only access to a database. I created this user with the default tablespace that is needed. I granted the CONNECT role to him as well as CREATE SESSION. When the user connects via SQL Developer and clicks on the + sign in front of the Tables it comes back empty...

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...

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...

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...

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...

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...

I am new to Oracle administration and have an issue with our current backup. From what I see, our retention policy is set to 7 days. The backup runs and as part of the backup it pulls all the small archivelogs into fewer larger archivelogs. Given the retention policy, within a week I should be...