Oracle
in [SQL]
|
Duplicate with no archive log files I ran the following command, "Duplcate target database to dupdb nofilenamecheck". I received the error that no log files were present or unable to preform media recivery because of missing log. I have now copied the archive logfiles over to my dupdb server. waht command would i perform next to fix my stupid mist... 17 Jul 2008 06:30
resynch duplicate oracle DB I have a duplicate database already setup that uses trhe same DBID. If i want to synch that database I found in the books that I can run the following commands: # start RMAN and then connect to the databases CONNECT TARGET; CONNECT CATALOG rman/cat(a)catdb; CONNECT AUXILIARY SYS/oracle(a)dupdb; # configure auxil... 16 Jul 2008 17:10
lag and update hello group, 10g: i've got this table "z" with following attributes: id dat ... date value, not necessarily consecutive k ... some numeric value k_vt the first 3 columns are filled, k_vt shall be filled with value of k of the previous day. I can't do it like this because of ora-30483: update t... 17 Jul 2008 07:32
no free space in tablespace Hi Today I have problem. In tablespace I don't have free space. I add datafile to that tablespce. Should I do or check something else to be sure that everything is ok? Thanks in advance, kawu. ... 30 Jul 2008 10:14
Oracle reports end query Hi, We are migrating from Oracle 6i to Crystal Reports. Oracle reports were built using Oracle 6i Data Wizard and Query Builder. How can we see the end query (final query including joins for links) that is being executed by Oracle Reports? Oracle Reports 'trace' shows only parts of queries being executed, but no... 28 Jul 2008 13:05
user groups in b.c. hi i was looking around for oracle user groups in vancouver, b.c. but there doesn't seem to be one... there's one in victoria, but i'm curious if there are any other groups nearby. as well, i would like to be able to sneak out of the office once in a while and go to some events ... i just haven't got much of ... 16 Jul 2008 13:00
Migrating an Application from SQL Server 2000 to Oracle 10g We have an application that was written using SQL Server 2000 as the RDBMS. We now have a need to convert this to Oracle. We know that we obviously need to hire an Oracle DBA, but we don't have one at this time... Our application uses queries with joins across databases. In SQL Server this is acheived like so: ... 24 Jul 2008 14:58
ORA-01092: ORACLE instance terminated. Disconnection forced Hi All, I'm a newbie in oracle & try to change undo_management=AUTO to MANUAL. I know that Oracle recommends AUTO, but I just want to test the procedure to change. Below are the steps that I follow & it's fails to startup DB. By looking at the log file, I know that missing the rollback01 segment is the rootca... 15 Jul 2008 17:29
Union question Hi, We have this HUGE query. It is dynamically built, so it will be different each time. The problem is, we need to order each query, not the entire UNION. So, each select needs to have it's own order by. Can this be done in any way?? SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc... 15 Jul 2008 13:20
Union question Hi, We have this HUGE query. It is dynamically built, so it will be different each time. The problem is, we need to order each query, not the entire UNION. So, each select needs to have it's own order by. Can this be done in any way?? SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc... 15 Jul 2008 16:27 |