Search
Search titles only
By:
Search titles only
By:
Forums
New posts
Search forums
What's new
New posts
Latest activity
Feedback
View Statistics
Members
Current visitors
Buy Sell Trade
WTB
Log in
Register
Search
Search titles only
By:
Search titles only
By:
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Forums
Technology
Programming
Help with a College VB project
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="coolpcguy" data-source="post: 889576" data-attributes="member: 26094"><p>The only way to know the Oracle version is</p><p></p><p>1. Logon to SQL*Plus where it will show the Oracle version.</p><p></p><p>2. Query v$ version</p><p></p><p>[code]SQL> SELECT * FROM V$VERSION</p><p></p><p> 2 /</p><p></p><p>BANNER</p><p></p><p>----------------------------------------------------------------</p><p></p><p>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi</p><p></p><p>PL/SQL Release 10.2.0.1.0 - Production</p><p></p><p>CORE 10.2.0.1.0 Production</p><p></p><p>TNS for Linux: Version 10.2.0.1.0 - Production</p><p></p><p>NLSRTL Version 10.2.0.1.0 - Production[/code]</p><p></p><p>This is a good way</p><p></p><p></p><p></p><p>Other wise make use of a flag or file to indicate a status if its first run, and if so deploy the schema.</p><p></p><p>To deploy the schema you can </p><p></p><p>(a) As mentioned create a script containing all DDL statements</p><p></p><p>(b) Export your schema & import them into the environment where you want to setup. Be sure to have a datapurge script to clear off all of *your* data, if you are going ahead.</p><p></p><p>I had written a blog post long ago - on exporting/importing using Oracle's exp/imp tools, <a href="http://sathyabh.at/2008/12/01/exporting-and-importing-an-oracle-database-from-one-schemauser-to-another-schemauser-easily/" target="_blank">link to it</a></p><p></p><p>Do read it, as I've mentioned a very easy tool for the same.</p><p></p><p>ED: Btw to obtain the DDL statement, use <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" target="_blank">Oracle SQL Developer</a>. Even for normal ad-hoc queries you ought to use it, its fantastic.</p></blockquote><p></p>
[QUOTE="coolpcguy, post: 889576, member: 26094"] The only way to know the Oracle version is 1. Logon to SQL*Plus where it will show the Oracle version. 2. Query v$ version [code]SQL> SELECT * FROM V$VERSION 2 / BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production[/code] This is a good way Other wise make use of a flag or file to indicate a status if its first run, and if so deploy the schema. To deploy the schema you can (a) As mentioned create a script containing all DDL statements (b) Export your schema & import them into the environment where you want to setup. Be sure to have a datapurge script to clear off all of *your* data, if you are going ahead. I had written a blog post long ago - on exporting/importing using Oracle's exp/imp tools, [URL="http://sathyabh.at/2008/12/01/exporting-and-importing-an-oracle-database-from-one-schemauser-to-another-schemauser-easily/"]link to it[/URL] Do read it, as I've mentioned a very easy tool for the same. ED: Btw to obtain the DDL statement, use [URL="http://www.oracle.com/technology/products/database/sql_developer/index.html"]Oracle SQL Developer[/URL]. Even for normal ad-hoc queries you ought to use it, its fantastic. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Technology
Programming
Help with a College VB project
Top
Bottom