|
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.
|
|
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.
|
|
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.
|
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.
|
|
Using ActiveX Data Objects 2.8 Library as a Reference from Excel VBA, and the connection string is:
"Driver={Microsoft ODBC for Oracle} "
And I also have the "Microsoft ODBC for Oracle" (MSORCL32.dll) entry in the Drivers tab of Windows XP's ODBC Manager...
Started by Saobi on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
But have you tried using Oracle Instant Client ? It's pretty painless....
I'm pretty sure you need to install Oracle client; what's more, I believe it has to be Oracle 8 Client (MS hasn't updated that driver in years, as far as I know).
|
|
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(?).
|
|
Other than querying the v_$database and v_$instance tables (or the views v$instance, v$database) is there any other way to programtically retrieve (from PL/SQL) the database name of an oracle database?
Started by Jeff on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Dbms_standard.database_name
Found the following on Experts Exchange:
select ora_database_name://www.experts-exchange.com/Databases/Oracle/Q_20529577.html.
|
|
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.
|
|
In phpmyadmin, it's able to see database disk usage. I was wondering if there's such thing in Oracle SQL developer. Thanks!
Started by Stan on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
OR (t.target_type ='oracle_database' AND t.TYPE_QUALIFIER3 != 'RACINST')) AND m.target_guid =t.target_guid database execute this query (History of DB size):
SELECT DECODE(m.metric_column, 'ALLOCATED_GB FROM mgmt$target WHERE target....
|
|
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....
|
