Difference between SYS and SYSTEM in Oracle 10g?
Of course there r some differences …. <b>SYS:</b> All of the base tables and views for the database’s data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by [...]
View Answer
| November 23, 2010 8:57 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle User Profiles
Of course there r some differences …. <b>SYS:</b> All of the base tables and views for the database’s data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by [...]
View Answer
| November 23, 2010 8:57 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle User Profiles
Oracle 10g Express commit statement error
That is definitely a message indicating that autocommit is ON. No other circumstance would produce that message. If you were running this in SQL*Plus or SQL Command Line, then the “show all” command (or “show autocommit”) suggested by Rechil will show you the autcommit status, but issuing a commit in a SQL*Plus or SQL Command [...]
View Answer
| November 22, 2010 7:03 PM
Oracle 10g, Oracle 10g error messages, Oracle 10g Express, Oracle error messages
That is definitely a message indicating that autocommit is ON. No other circumstance would produce that message. If you were running this in SQL*Plus or SQL Command Line, then the “show all” command (or “show autocommit”) suggested by Rechil will show you the autcommit status, but issuing a commit in a SQL*Plus or SQL Command [...]
View Answer
| November 22, 2010 7:03 PM
Oracle 10g, Oracle 10g error messages, Oracle 10g Express, Oracle error messages
User name and schema name in Oracle 10g
You can if you also use it in the FROM clause. So, your exampe query would look like this: select<b> jaga.</b>emp.name from <b>jaga.</b>emp where age>100 But, if you are querying just one table you don’t need to qualify the fields in the select list.
View Answer
| November 22, 2010 4:21 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Schema
You can if you also use it in the FROM clause. So, your exampe query would look like this: select<b> jaga.</b>emp.name from <b>jaga.</b>emp where age>100 But, if you are querying just one table you don’t need to qualify the fields in the select list.
View Answer
| November 22, 2010 4:21 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Schema
AS/400 SFTP causes one position shift of data in send file
There are two (for want of a better word) modes in which to transfer – or, two STRUCTures. Record or File mode. on the iSeries, start an FTP session, and run the command STRUCT without any parms. This reports back the current setting. I would try to flip the mode and see if this helped [...]
View Answer
| November 19, 2010 8:14 PM
AS/400 flat file, AS/400 SFTP, Oracle, Oracle File Authentication, SFTP
There are two (for want of a better word) modes in which to transfer – or, two STRUCTures. Record or File mode. on the iSeries, start an FTP session, and run the command STRUCT without any parms. This reports back the current setting. I would try to flip the mode and see if this helped [...]
View Answer
| November 19, 2010 8:14 PM
AS/400 flat file, AS/400 SFTP, Oracle, Oracle File Authentication, SFTP
Tomorrow at 4PM ET: ITKE Rolls Out New Badge System
cool.. all the best with the rolling out changes
View Answer
| November 19, 2010 4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003
cool.. all the best with the rolling out changes
View Answer
| November 19, 2010 4:22 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server 2003
ORA-1555 insert table with 3 billions rows in Oracle with SQL
The problem is probably being caused by the commits you are issuing every 200,000 rows. When the number of transactions created after the cursor was opened increase, the chances of getting this error also grow if you continue fetching data from the cursor. From the DBA perspective, maybe increasing the number and/or size of the [...]
View Answer
| November 18, 2010 8:20 PM
ORA-1555, Oracle 9i, Oracle Tables, SQL
The problem is probably being caused by the commits you are issuing every 200,000 rows. When the number of transactions created after the cursor was opened increase, the chances of getting this error also grow if you continue fetching data from the cursor. From the DBA perspective, maybe increasing the number and/or size of the [...]
View Answer
| November 18, 2010 8:20 PM
ORA-1555, Oracle 9i, Oracle Tables, SQL
Can I direct query the Oracle database with SQL Plus?
With the appropriate credentials, you could connect to the database from SQL*Plus, and you would be able to query it if you know the appropriate object names and the user account has the appropriate privileges. So, it depends.
View Answer
| November 18, 2010 3:08 PM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
With the appropriate credentials, you could connect to the database from SQL*Plus, and you would be able to query it if you know the appropriate object names and the user account has the appropriate privileges. So, it depends.
View Answer
| November 18, 2010 3:08 PM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
ORA-06550 and PLS-00103 error
There are several errors in your code. First, if you are trying to create a stored procedure, remove everything that is before the CREATE OR REPLACE PROCEDURE command. Second, every variable that is going to be referenced in the stored procedure code needs to be declared inside the procedure (as a variable or as a [...]
View Answer
| November 16, 2010 5:45 PM
ORA-06550, Oracle, Oracle Error Codes, Oracle error messages, Oracle errors
There are several errors in your code. First, if you are trying to create a stored procedure, remove everything that is before the CREATE OR REPLACE PROCEDURE command. Second, every variable that is going to be referenced in the stored procedure code needs to be declared inside the procedure (as a variable or as a [...]
View Answer
| November 16, 2010 5:45 PM
ORA-06550, Oracle, Oracle Error Codes, Oracle error messages, Oracle errors
Oracle Reports 6i
To change the orientation (portrait or landscape) of a report section: 1. In the Object Navigator, expand the Layout Model node, click the node for the section (by default, a report is defined in the Main Section), then choose ToolsProperty Palette. 2. In the Property Palette, under the Section node: -set the Width and Height [...]
View Answer
| November 15, 2010 11:23 PM
Oracle Reports, Oracle Reports 6i, Oracle Reports Developer, Oracle Views
To change the orientation (portrait or landscape) of a report section: 1. In the Object Navigator, expand the Layout Model node, click the node for the section (by default, a report is defined in the Main Section), then choose ToolsProperty Palette. 2. In the Property Palette, under the Section node: -set the Width and Height [...]
View Answer
| November 15, 2010 11:23 PM
Oracle Reports, Oracle Reports 6i, Oracle Reports Developer, Oracle Views
Error Message ORA-00903 in SQL table
ORA-00903 IS “invalid table name”. Maybe you are receiving an ORA-00904, which means “invalid column name”. If tourid is a defined attribute in a table called Tour, then you can only use it when querying that table.
View Answer
| November 15, 2010 5:19 PM
ORA-00903, SQL, SQL Plus, SQL tables
ORA-00903 IS “invalid table name”. Maybe you are receiving an ORA-00904, which means “invalid column name”. If tourid is a defined attribute in a table called Tour, then you can only use it when querying that table.
View Answer
| November 15, 2010 5:19 PM
ORA-00903, SQL, SQL Plus, SQL tables
Terminate SQL exception, if it is running more than a specified time.
If the script is being called from a client application then you can set a query timeout (typically 30 seconds by default) and have the client driver kill the query automatically. This isn’t always the best practice as you usually want the query to complete and return the needed data.
View Answer
| November 15, 2010 12:42 PM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement
If the script is being called from a client application then you can set a query timeout (typically 30 seconds by default) and have the client driver kill the query automatically. This isn’t always the best practice as you usually want the query to complete and return the needed data.
View Answer
| November 15, 2010 12:42 PM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement
Oracle 10g on Windows7 Home Basic 64-Bit OS
U may follow the Oracle Documentation, it is a good documentation about installation all about. If possible u may link to this to get information about ur Q: http://it.toolbox.com/blogs/oracle-guide/oracle-11g-64bit-on-windows-7-ultimate-64bit-29240 But it is on Oracle 11G. Hope it will help u….
View Answer
| November 15, 2010 9:17 AM
Oracle 10g, Windows 7, Windows 7 64-bit
U may follow the Oracle Documentation, it is a good documentation about installation all about. If possible u may link to this to get information about ur Q: http://it.toolbox.com/blogs/oracle-guide/oracle-11g-64bit-on-windows-7-ultimate-64bit-29240 But it is on Oracle 11G. Hope it will help u….
View Answer
| November 15, 2010 9:17 AM
Oracle 10g, Windows 7, Windows 7 64-bit
jrew.exe has stopped working when iam tryin to install oracle 8i on Windows Server 2008
Oracle 8i is not supported on Windows Server 2008. The latest version on which the 8i database server works without issues is Windows Server 2003.
View Answer
| November 11, 2010 2:08 PM
Oracle 8i, Oracle 8i Installation, Oracle installation, Windows Server 2008
Oracle 8i is not supported on Windows Server 2008. The latest version on which the 8i database server works without issues is Windows Server 2003.
View Answer
| November 11, 2010 2:08 PM
Oracle 8i, Oracle 8i Installation, Oracle installation, Windows Server 2008
Invalid credentials in Oracle Database 10g?
Try with the SYS or INTERNAL users.
View Answer
| November 11, 2010 1:46 PM
Oracle administration, Oracle Database, Oracle Database 10g, Oracle User Profiles
Try with the SYS or INTERNAL users.
View Answer
| November 11, 2010 1:46 PM
Oracle administration, Oracle Database, Oracle Database 10g, Oracle User Profiles
Oracle Database 10g Express Edition error while login
when i start the oracle databse i got the error like “net is not recognized as an internal or external command, operable program or batch file.
View Answer
| November 11, 2010 11:59 AM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g Express Edition, Oracle installation
when i start the oracle databse i got the error like “net is not recognized as an internal or external command, operable program or batch file.
View Answer
| November 11, 2010 11:59 AM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g Express Edition, Oracle installation
Career in Java
If u are planning to enter a career in application development or software project management using Java technology, SCJA would be the best choice. Though U mentioned done Java & J2EE so achieving the SCJP certification provides clear evidence that a programmer understands the basic syntax and structure of the Java programming language. If ur [...]
View Answer
| November 11, 2010 6:53 AM
J2EE, Java, Java developer, OBIEE
If u are planning to enter a career in application development or software project management using Java technology, SCJA would be the best choice. Though U mentioned done Java & J2EE so achieving the SCJP certification provides clear evidence that a programmer understands the basic syntax and structure of the Java programming language. If ur [...]
View Answer
| November 11, 2010 6:53 AM
J2EE, Java, Java developer, OBIEE
I know SQL, should I learn Oracle database?
Yes, if you have some SQL (the language, not SQL Server) knowledge it will surely help you. The first thing I would recommend would be to <a href=”http://www.oracle.com/technetwork/database/express-edition/downloads/index.html”>download the express edition of Oracle Database 10g</a>, which is completely free. Then you can start learning from the <a href=”http://www.oracle.com/pls/xe102/homepage”>documentation library</a> which includes interesting courses such as [...]
View Answer
| November 10, 2010 2:32 PM
Oracle Careers, Oracle certifications, Oracle Database, SQL Server
Yes, if you have some SQL (the language, not SQL Server) knowledge it will surely help you. The first thing I would recommend would be to <a href=”http://www.oracle.com/technetwork/database/express-edition/downloads/index.html”>download the express edition of Oracle Database 10g</a>, which is completely free. Then you can start learning from the <a href=”http://www.oracle.com/pls/xe102/homepage”>documentation library</a> which includes interesting courses such as [...]
View Answer
| November 10, 2010 2:32 PM
Oracle Careers, Oracle certifications, Oracle Database, SQL Server
Dbms_repair
The dbms_repair utility provides a mechanism to search for corrupt database blocks. Below is the syntax for the check_objects procedure. The syntax is dbms_repair.CHECK_OBJECT ( schema_name IN VARCHAR2, object_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, object_type IN BINARY_INTEGER DEFAULT TABLE_OBJECT, repair_table_name IN VARCHAR2 DEFAULT ‘REPAIR_TABLE’, flags IN BINARY_INTEGER DEFAULT NULL, relative_fno IN BINARY_INTEGER DEFAULT [...]
View Answer
| November 10, 2010 9:26 AM
Oracle
The dbms_repair utility provides a mechanism to search for corrupt database blocks. Below is the syntax for the check_objects procedure. The syntax is dbms_repair.CHECK_OBJECT ( schema_name IN VARCHAR2, object_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, object_type IN BINARY_INTEGER DEFAULT TABLE_OBJECT, repair_table_name IN VARCHAR2 DEFAULT ‘REPAIR_TABLE’, flags IN BINARY_INTEGER DEFAULT NULL, relative_fno IN BINARY_INTEGER DEFAULT [...]
View Answer
| November 10, 2010 9:26 AM
Oracle
oracle internet directory application developer’s guide — dbms_ldap_utl sample code doesn’t work
Please go to this link, which I provide below : www.oracle.com/technology/sample_code/products/id_mgmt/javaapi/SampleUser/readme.html
View Answer
| November 10, 2010 9:20 AM
Application security, Biometrics, Database, Development, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Oracle, provisioning, Secure Coding, Security, Security tokens, Single sign-on, SQL
Please go to this link, which I provide below : www.oracle.com/technology/sample_code/products/id_mgmt/javaapi/SampleUser/readme.html
View Answer
| November 10, 2010 9:20 AM
Application security, Biometrics, Database, Development, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Oracle, provisioning, Secure Coding, Security, Security tokens, Single sign-on, SQL
Removing default window in Oracle Forms 10g
To remove the default window that is created when you create a new form (which is by default called window1) you just have to select it in Object Navigator and click on the red “x” button to the left, or hit the ‘Delete’ key on your keyboard. If that’s not what you mean, please provide [...]
View Answer
| November 9, 2010 7:51 PM
Oracle, Oracle 10g, Oracle default parameters, Oracle Forms 10g
To remove the default window that is created when you create a new form (which is by default called window1) you just have to select it in Object Navigator and click on the red “x” button to the left, or hit the ‘Delete’ key on your keyboard. If that’s not what you mean, please provide [...]
View Answer
| November 9, 2010 7:51 PM
Oracle, Oracle 10g, Oracle default parameters, Oracle Forms 10g
