Description:
Oracle database administration/server topics.
|
|
|
Rman Question
|
| |
I need to restore a copy of our database on a different server. I have full backups going back 4 weeks plus cumulative backups. I'm not sure where the problem happened. So, I figure I can restore the earilest copy, and if that is not it, restore the next full backup...... Anyhow, I am looking for some decent documentation that will tell me... more »
|
|
|
iptables settings for 10g RAC
|
| |
I have created a 10g RAC database, and want to lock down the individual servers with iptables. Can someone give me some sample rules which will allow free communication between server A and server B, for both the pub/vip/priv interfaces? Thanks Greg
|
|
|
Oracle 10g Recycle Bin
|
| |
Hi, I've read all about Oracle uses the recycle bin and how it purges objects when it needs space, etc. But, is there any way to manually control that, meaning to keep the objects in there longer? Other than increasing the size of the tablespace?? Thanks
|
|
|
triggers on views
|
| |
Creating a database as a part of a school project, I ran into a problem that was solved by switching place of two rows that by the look of them would suggest their order would be irrelevant. The situation was roughly as follows: A view was created as a union of two tables. Two "instead of" trigger was created to handle insert and deletes on... more »
|
|
|
Utility for creating a ZIP file from BLOBs?
|
| |
Hi 10g R2 - 10.2.0.1.0 on Linux RHEL4 We have a number of documents in the database stored as BLOBs. Increasingly we are being asked to provide a method by which a number of these can be delivered to a user as a ZIP file. The application is web-based and uses the web pl/sql toolkit. I'd rather not use any o/s dependent utilities unless absolutely necessary (maximum... more »
|
|
|
Need Help: Getting hang while importing schema dump
|
| |
Hi, System getting hang when I am trying to import schema dump into new schema. Actually, I am just creating duplicate schema in same DB. Consider, I have two schema A and B on the same DB and now I have exported schema A and trying import same into B.But while importing type object, its getting hang for couple of hours.... more »
|
|
|
Made by TVO/Posiva/Tem ydintaivaat.
|
| |
Oli taas härski vedätys ydinalaltamme. Eli ei antanut Kalli julkisuuteen edes sitä laajasti tunnettua faktaa, että hänen mm. 60v juhlat järjesti, kas kummaa TVO! Olisi toimittajilta kyllä ollut minimi vaatia edes näin räikeää faktaa esille. Mutta kuten olemme saaneet tottua ydinhallinnon tekemiin... more »
|
|
|
Function based index not used with like operator
|
| |
Hi! I have two tables A and B where I in both tables have a function index (upper case) on a column. When I do a query like Select col1, col2 from A where upper(col_with_ucase_index) like 'ABC%' and I verify the execution plan it uses the upper case index on col_with_ucase_index when I run a query against table A.... more »
|
|
|
Trying to get more interest in Dataphor starting with my blog
|
| |
Greetings, I'm sure some here know of Dataphor. Dataphor is an open source project RAD tool that has a relational engine encorporating many of the ideas expressed by Date and Darwen in TTM (the third manifesto, an outline of a future db). I have been blogging about it for a while now in the hopes of encouraging sql users (as well as application... more »
|
|
|
