|
I have access to an Oracle server that has some databases that I would like to access. However, the machine that I have access from has none of the oracle client software. Is there any alternative to oracle's client software the provides the functionality...
Started by Paul Wicks on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Oracle's free PL of databases....
If you download the free Oracle Instant Client you'd be able to use any JDBC or ODBC Database tool which will give you an Oracle sqlplus command line without a full Oracle install.
|
|
Looking for tools on a windows platform to genereate ER diagram (or similar) from an existing Oracle database.
Any good tools out there that are free to use or low cost?
Started by Kb on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Crank up MS Access....
It is from oracle and is going to be part of actual oracle hurry.
From VISIO (Database ModelTry out Oracle SQL Developer .
With an ODBC data source (oracle plugin) to generate ER diagrams - works well.
|
|
I'm trying to connect to an Oracle 10g database using the built in Microsoft ODBC for Oracle driver. I want to use an dnsless connection, so I grab my connection string from www.connectionstrings.com .
Ideally I won't have to setup a DNS entry or an Oracle...
Started by Gaidin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
To connect to an Oracle instance....
Alternatively, you can go to the gui interface for that file at
Start->Programs->Oracle->Configuration and Migration Tools->Net Configuration Assistant
and set up your oracle connection.
|
Ask your Facebook Friends
|
I need to connect and perform some operation on oracle database from my C#/.NET application. Since it is a high load server application, I wish that I use only async calls to do database operations.
I understand that System.Data.OracleClient is obsolete...
Started by Hemant on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
There....
You could use DBMS_JOB or the more modern DBMS_SCHEDULER to have Oracle run something and then return.
Oracle have also similar concept.
That all can be done in a single query.
In sqlserver then schedule it to execute immediately.
|
|
Is there are any sample database for Oracle like AdventureWorks for MS SQL? I've searched Oracle site but didn't found any sample database.
Started by GTD on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Good Databases with sample data
The Oracle database.
This question can be of some help(?).
|
|
At the moment I pull data from remote MS SQL Server databases using custom-built JDBC connectors. This works fine but doesn't feel like the way to do it.
I feel I should be able to put a JDBC connection string into tnsnames on the server and have it "...
Started by Nick Pierpoint on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
With Oracle being such keen Java fans, and with a JVM built-in to the database I'd have thoughtGeneric Connectivity....
For Generic Connectivity, if you're running on Linux...
With the database license and Oracle Gateways is an add-on.
|
|
The application part of my database is in Access 2003, and I use tables that are linked from SQL server. Now, I have some tables that I have to link from an Oracle database. I link them through and ODBC connection and it works fine. Is it possible to ...
Started by Jasmin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
That connection!? I what to establish connection from sql server to oracle database link! Is that possible mapping as some types in oracle may get mapped to a slightly different type in SQL than when accessed: To "establish a connection....
|
|
Do you use any free tool to generate query for oracle database. Tool that autocomplete and suggests the table names and column names.
Started by yesraaj on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Unfortunately, the project.
Written and maintained by Oracle themselves it with Oracle, but I would be surprised if it doesn't work in that context.
Oracle SQL Developer has auto-complete and such.
|
|
IANADBA, but I'm writing a script that will take action as long as the oracle standby database hasn't been activated. What I'm looking for is two queries (or sets of queries, if necessary).
1 - Is the database mounted (as in, has someone done "alter database...
Started by Matt Simmons on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
This works for a physical standby, Oracle 10g:
SELECT open_mode FROM v$database;
If the value of the database for example
SELECT INSTANCE_NAME, DATABASE_STATUS, INSTANCE_ROLE, ACTIVE_STATE FROM v$instance;
Could you monitor....
|
|
We have an Oracle 8i database that our developers run against and we currently use the 9i enterprise manager to view tables/values and do some minor manual data editing.
I was wondering if there is a more modern tool to use than OEM 9. One major annoyance...
Started by Matias Nino on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
It is made by the database makers for nearly every Oracle....
SQL Developer is good.
It is targeted at Oracle, so it has support
Recommended for Oracle Developers and DBA.
Toad is the best database manager on the market.
|
