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

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

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

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

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

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

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

That is exactly what I wanted. Thank You!

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

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

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

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.

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

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

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

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