Relative Content

Tag Archive for oracle

oracle synonym vs database link

I am doing this. I created a database link, then a synonym to the table I needed, then created the table from my prod database to my development database. I have some questions about this. What is the difference between the synonym and database link? Having a synonym and database link does seem to cause problems though. I have to reset my password every 30 days. I often forget about the synonym and database link. So this is causing me to lock by databases then I have to bug the DBA’s to unlock my databases. Should I drop both the database link and synonym, should I drop just the synonym, should I drop just the database link? Are they needed after I create the database? I only drop and recreate the table once a year because there are plenty of records to work with after I create the table.

is Oracle ADF Mobile free? and what is it’s usage scope? [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago. I would like to know whether Oracle ADF […]

DB API for shell scripting (any shell)

I am faced with some legacy shell scripts that run batch data processing jobs in Oracle using SQL+. For the most part, the data tier does not have to communicate back to the script with retrieved data to be passed for shell-level processing but in a few cases it does.

Reporting and handling asynchronous process errors to a client

I have a product with two separate applications. The core of the product lives in the database (oracle) and runs according to a schedule. The other is a client application (currently ASP.NET MVC3) used to manage the database application. There are three levels of validation going on; client, server-side, and database before the client data is saved to the database.

Should heavy binary files not be stored in database? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for […]

Sorting rows off an autoincrementing primary key

Is it a bad practice to rely on an auto-incrementing primary key to sort rows in a table? A coworker and I were having an argument about this subject. We need to be able to find the last-inserted row in a table, and we have no create/update time columns (which might be considered a bad practice in itself, but that’s a different argument). We obviously can’t rely on the natural order of the rows, since that can be inconsistent. Is there anything inherently wrong with using the primary key in this way, given that it’s an immutable value?

What is the equivalent of Entity Framework in the world of Oracle shops? [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago. Within the world of developers/firms specializing in building/deploying […]

.NET software design and Oracle ODP.NET UDT

I’m working on a new common .NET software design (mainly) for WCF-based web service applications with related client frontends (all written in C#). As far I’ve chosen some frameworks (NUnit,Autofac/Castle Windsor) as basis for the application.

Oracle Database Integration with Team Foundation Server?

So my company is using TFS and SQL to Manage their Database (MS SQL Server). It integrates with the nightly build servers to do builds and produce scripts to build the entire Database. Also the Compare Schema tool that visual studio offers is really handy.