ORA-02068 and 03113
These errors are usually the result of a network problem. Have you checked if the remote database is up and running at the time of the failure, and if the network connection of the remote machine is working as expected ? We had a similar problem some time ago, but the two databases resided in [...]

View Answer   |  September 16, 2008  5:11 PM
DBLink, ORA-02068, ORA-03113, Oracle

Export to CSV or dump file
You can export both, database or specific tables to a dump file with the EXPORT utility. You could use this syntax: exp <username>@<host_string>/<password> file=<target_file_name> [tables=<comma_separated_list_of_Tables>] for example: – exports the complete database exp scot@test_db/tiger file=database_backup.dmp or – export specific tables exp scot@test_db/tiger file=database_backup.dmp tables=table_a,table_b,table_c Many more parameters exist for the EXPORT utility. You might want [...]

View Answer   |  September 16, 2008  2:28 PM
CSV, Export, Oracle 10g

Host Credentials
Unless Oracle is configured to use Active Directory it wants the Oracle credentials not your OS credentials.

View Answer   |  September 13, 2008  10:26 PM
Enterprise Manager, Host credentials, Vista compatibility

oracle form:export to excel
If you didn’t find the way to export your data to excel, you could easily export it to a csv file (which are by default open with excel) using the package TEXT_IO. Regards,

View Answer   |  September 13, 2008  7:17 PM
Microsoft Excel, Oracle, Oracle Forms, Oracle import/export

ORA-1034: Oracle is not available error with SQL Plus
This error message generally means that your database instance is not running. Check at your services (control_panel->administrative_tools->services) if a service called OracleService<YourDatabaseName> is running, and start it if it is not running. You also might want to set its startUpType to “Automatic”. Regards,

View Answer   |  September 13, 2008  7:14 PM
ORA-1034, Oracle, Oracle error messages, SQLPlus

Items in Pending Transactions of Inventory Module
Could you please paste your code here ? (the contents of i2471362.sql) A little more information would be great also.

View Answer   |  September 13, 2008  7:02 PM
Oracle administration, Oracle import/export, Oracle installation

Most common oracle DBA tool.
That would be <a href=”http://www.quest.com/toad/”>TOAD</a>, currently by <a href=”http://www.quest.com/”>Quest Software</a>. Embarcadero – DBArtisan is much easier and has the best GUI interfaces.

View Answer   |  September 12, 2008  4:29 PM
Oracle administration, Oracle DBA

When do I use a collection instead of a table
I have not used collections in version 10g, but as far as I know, you cannot make comparisons between two complete collections, so, for what you want to do I think it would be a better approach to use temporary tables. Collections can be really useful, but it depends on what you want to accomplish. [...]

View Answer   |  September 11, 2008  3:29 PM
Oracle 10g, SQL

Evidence of RMAN backup run
If you run RMAN with a respository, then oracle will store that information in tables in this database. Data will be kept and grow (just like all tables) and then rman management will be needed to remove obsolete records. When you do not use a recovery catalog, the control file is the sole source of [...]

View Answer   |  February 25, 2013  7:26 PM
Oracle backup, RMAN

Is there a config file to set sqlplus default to GMT?
try this : <pre> alter session set time_zone </pre>

View Answer   |  September 9, 2008  7:09 PM
SQLPlus

Error accessing Oracle data using SQL job
Sounds like someone has uninstalled the Oracle drivers from the SQL Server. Try reinstalling the Oracle drivers on the SQL Server.

View Answer   |  September 9, 2008  9:40 AM
DTS Package Scheduled Task, OLE DB, Oracle 7, SQL Server 2000

Error when translating execute immediate from Oracle to SQL
Do a CAST on the emps$emp_id from an integer to a text string before putting it into the @upd variable.

View Answer   |  September 9, 2008  8:31 AM
O2SS0013, O2SS0356, Oracle error messages, Oracle import/export, Oracle migration, SQL Server import/export, SQL Server Migration Assistant, SSMA, SSMA for Oracle, SSMA warning messages

Need career advise ORACLE or SAP?
I would go online and check if there are more opportunities in Oracle Financials or in SAP, regardless you have to learn a new software package as all companies use an Accounting software package these days. The sooner you learn the better it is for you. I can talk about SAP as don’t know Oracle [...]

View Answer   |  September 9, 2008  6:58 AM
IT careers, Oracle certifications, SAP careers

Community Update: New Member Contest Win a XBox 360 this month for your participation.
<b>Update 9/8</b> Things are close after the first week and it is still anybody’s contest to win After the first week the standings are: MrDenny 645 SchmidtW 625 Labnuke99 435 WRobinson 435 There is still time for other to gain Knowledge Points by asking, answering and discussing questions.

View Answer   |  September 8, 2008  1:42 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Storage, Virtualization, Virtualization and the hypervisor, VoIP

Error(55,8): PLS-00103: Encountered the symbol “C1″ when expecting one of the following: := . ( @ % ;
You need the word DECLARE, your statement should look like: DECLARE CURSOR C1 IS select SUB_ID FROM FRAUDS_SIU_ADMIN.FRAUDS_SUBMISSION; good luck

View Answer   |  September 6, 2008  1:23 PM
Oracle error messages, PLS-00103

Oracle 9i Support
Oracle 9i Release 2 (9.2.0) Status: Desupported, however, Oracle had waived their usual fees for extended support until July 2008. For more info, see <a href=”http://www.oracle.com/features/hp/database-9i-support.html”> http://www.oracle.com/features/hp/database-9i-support.html</a> Last patch-set: 9.2.0.8 Premier Support Ends: 31-Jul-2007 Extended Support Ends: 30-Jul-2010 See <a href=”http://www.oracle.com/support/lifetime-support-policy.html”>Oracles Lifetime Support Policy.</a>

View Answer   |  September 4, 2008  3:45 PM
Oracle 9i

Oracle D2K report printing extra space at ery page problem
First this is not clear that the report is Bitmap or Character. Try to check the default setting of the printer by self testing and check that the height parameter is 12 inch. If u r using Character mode in Reports then u should check dimension in the .prt file which u can found in [...]

View Answer   |  September 4, 2008  9:27 AM
.prt files, Developer 2000, Epson LQ1050+, Oracle 8i, Oracle Reports

Commit during loader replace ?
Cgfchat, I can’t answer that question directly and unable to test it at this time. However this information may assist you in your testing. The REPLACE keyword says, “remove any existing rows before starting the load.” You can’t stop a commit from occurring during SQL*Loader loading, but by setting the ROWS= parameter to a large [...]

View Answer   |  September 3, 2008  3:27 PM
Oracle development, SQL*Loader

Oracle ignores hints
Hello Sueterrin. I don’t think Oracle ignore hints. I think there must be something else causing this behavior. Optimizer hints does not cause syntax erors, so if the hint is not properly written there is no error, but the hint is ignored. It is also important to check whether the specified index exists and is [...]

View Answer   |  September 3, 2008  3:17 PM
hints, Oracle 10g

Oracle Data types
Hi, Positive scale means the number of digit to right of decimal point, when scale is bigger than precision than 0′s added before significant digits, in your case var1 will look like something like 0.0….012345, there will be 20 zeros. Negative scale on the other hand represents number of digits on the left of decimal [...]

View Answer   |  September 3, 2008  5:31 AM
Data Types, Oracle 9i