About Experts Sitemap - Group 39 - Page 21 2015-01-27

Oracle: recover deleted data, Flashback Query, Recover deleted data
Flashback Query, Recover deleted data, Oracle 11gR2: Hi Sabin, If you accidentally deleted (or inserted) rows of data BEFORE issuing a COMMIT statement (closing your SQL*Plus session also issues an explicit COMMIT), then you can issue a ROLLBACK statement to rollback that last transaction in that specific...

Oracle: SQL, asktom oracle, tom kyte
asktom oracle, tom kyte, agile development: Hi Gaurav Depending on what you are talking about with regarding to subquery. If you are using it as a scalar subquery, there is a hit to the performance because for each row it returns from the main query, it will need to fetch the data from the database...

Oracle: Base Help, unix shell scripting, solaris os
unix shell scripting, solaris os, oracle sql: Hi Arun, You can definitely do the certifications in Oracle SQL and PL/SQL. You can also check the development path certifications - Forms, Pro*C etc. If you have more experience in these technologies, then you can enhance your career further. Unix...

Oracle: oracle - need to convert multiple mutiple rows into single row, oracle error, loop method
oracle error, loop method, datatype: CLOB is basically used to store large data upto 4 GB. Why would you like to convert it to a single column ? Try to find the total size of all the coulumn s before trying to append them. select sum (lb ) from (select dbms_lob.getlength(clob_column)...

Oracle: problem: maximum open cursors exceeded, maximum open cursors, dynamic cursor
maximum open cursors, dynamic cursor, oracle: How oracle manages SYS_REFCURSOR ? How SYS_REFCURSOR gets closed ? SYS_REFCURSOR is used to open weak dynamic cursor. You need to manually close all the cursors after usage. Else if number of open cursors exceed maximum open cursors limit set in...

Oracle: unable to run sql developer, SQL Developer, configuration
SQL Developer, configuration, installation: Hi Vipa, 1. I am assuming that you are trying to use Oracle s Sql Developer v3.1. If you are installing the 32-bit Windows version, then you need to download this which includes the JDK: i- http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-3.1.07.42.zip...

Oracle: Career in Database, latest stable version, oracle 8i
latest stable version, oracle 8i, oracle dba: Hi Akshay, Good to know that you are interested in database side. My advice would be that first you study Oracle 10g which is the latest stable version, gain some experience by installing it on your PC and trying, then you will be fit to study anything...

Oracle: dba, future path, b tech
future path, b tech, joshi: Hi Hadi, Good to hear that you are persuing DBA career. It is a good area and has lot of growth. You can take any courses for DBA, but you have to start gaining experience at home by installing database, performing various activities etc. Practice is the...

Oracle: How to get all table?, employee details, oracle
Oracle: How to get all table?, employee details, oracle, little bit

Oracle: oracle, execution path, sclass
execution path, sclass, phani: Good day Phaneendra It is quite difficult to determine how it retrieve the information. Here is the reason (1) Is there any index (2) is the statistic keep up to date (3) how many rows in the table These are all the basic information to determine...

Oracle: Oracle DB - Constraint Tables, Oracle Objects; Constraints
Oracle Objects; Constraints: Hi Wilfred, The USER_CONSTRAINTS and USER_CONS_COLUMNS will only show the data that relates the owner of the objects. If those objects were created by anoter owner (or schema), then you will need to query the view ALL_CONSTRAINTS, with the filter of WHERE...

Oracle: Oracle/PS 9.0 to MS Access via ODBC, ODBC; Microsoft; Microsoft Access 2007
ODBC; Microsoft; Microsoft Access 2007: Hi Mary, Often times when you upgrade the Microsoft Access software, the ODBC drivers required to connect to the PeopleSoft (I am assuming that your PeopleSoft application is running on an Oracle RDBMS or database) is NOT updated. Many of these ODBC drivers...

Oracle: Oralce Interview Qs, dimensional data warehouse, automated teller machine
dimensional data warehouse, automated teller machine, microsoft excel pivot table: Good morning Gaurav, The answer to your questions is: it depends. 1. Replacing I take it to mean to restore a database from a backup . If you are doing a point-in-time, chances are you would have taken a backup. There are 2 types of backup you could...

Oracle: PL SQL, static table, satisfactory answer
static table, satisfactory answer, thanks in advance: The data in temporary tables will be available till session expires (ON COMMIT PRESERVE ROWS) or commit is issued (ON COMMIT DELETE ROWS). The data in a global temporary table is private, such that data inserted by a session can only be accessed by that...

Oracle: regd backup, export utility, code tables
export utility, code tables, thanks in advance: Hello Seshu, The best way is to take backup of your schema (user) using export utility, create new schema and import the backup in this schema. Then you can make changes in your current schema and compare with the new created one. Hope this helps. ...

Oracle: How to get all table?, db expert, oracle 10g
db expert, oracle 10g, using oracle: Hi Sanjay, As I have mentioned in my profile, I am not a DB expert but I will try to answer your query from PeopleSoft perspective (which is my expertise). You have an Oracle meta table called PSRECDEFN which stores the details of all the tables in the...

Oracle: Computers(ORACLE), dear madam, oracle database
dear madam, oracle database, warm regards: Hi Kuldeep, Depending on which version you want, please check on this sites - http://docs.oracle.com/cd/B10501_01/server.920/a96521/create.htm http://docs.oracle.com/cd/B19306_01/server.102/b14231/create.htm#ADMIN002 You will have to study this...

Oracle: on constraints, oracle constraints, constraint types
oracle constraints, constraint types, referential integrity: Good day Shankar You can find the Oracle constraints using one of the following tables - user_constraints - all_constraints - dba_constraints To retrieve the information that you are looking for, you can use the following SQL by adding your own condition...

Oracle: DBA career, dba oracle, proffession
dba oracle, proffession, sudhakar: Hi Sudhakar, DBA is a good area, but difficult to get entry level jobs. You will need more practice and experience to get in this area. But once you get a job, and prove yourself, it is worth continuing. It has a great future. Hope this helps. Regards...

Oracle: get the list of oracle database, Oracle Database on Microsoft Windows Platform, Oracle
Oracle Database on Microsoft Windows Platform, Oracle, database: Hi Kuldeep, There is no command on an MS-Windows platform that will provide a list of Oracle databases created or running. To look for a list of running Oracle databases, you can use the Task Manager (usually CTRL - ALT - DEL and select Task Manager...

Oracle: ORA-12514 with 11gR1, ORA-12514, Oracle Database
ORA-12514, Oracle Database, Error message: Hi Gourav, (reference http://ora-12514.ora-code.com/) The error message suggests two possible problems. 1. An attempt was made to connect to the database shortly after the Oracle Listener service was started and before the database could be registered...

Oracle: oracle, data dictionary, dictionary entry
data dictionary, dictionary entry, many tables: Hi Phaneendra, When you create tables in Oracle (or any database) and insert rows into it, the data is stored in the table in the database. When you run a query on this table, the data is fetched from the table and you get the results. Whereas when...

Oracle: oracle, Oracle View
Oracle View: Hi Phaneendra, When you create a table in Oracle, the physical structure of the table and the corresponding data that you eventually input/update are stored in the table. When you create a view, it is merely a pointer (often with a filter applied) against...

Oracle: oracle, data dictionary, dictionary entry
data dictionary, dictionary entry, hii: The explanation says : View is just a view and not a table and hence doesn t stores data. When view is created, the query associated with the view is stored in the data dictionary and when the view is referred the SQL statement associated with the view is...

Oracle: oracle, data dictionary, dictionary entry
data dictionary, dictionary entry, text column: Hi Phaneendra, The first point means that when you create a view (using emp table), the data from emp table is not stored in the view, only the query with which you created the view is stored in database. So when you select from a view, the data retrieved...

Oracle: Base benefits and ebenefits, benefit pension plan, benefit administration
benefit pension plan, benefit administration, enrollment options: Hi Mayuri, First, I must apologise for the delay in responding back. Here is the answer to your follow-up questions: 1) It would not matter as long as you create a NEW 8X PLAN TYPE for these pension plans (X stands for any digit or character).Plan...

Oracle: Oracle, dept id, pl sql
dept id, pl sql, sql statements: Hi Pooja, In simple terms, cursors are sql statements which can be declared in pl/sql, and then we can manipulate the cursor records as required. Record is a group of related data items stored in fields, each with its own name and datatype. cursor eg....

Oracle: Reg Surrogate key, montreal 2, oracle 10g
montreal 2, oracle 10g, john doe: Hi Radhakrishnan 1.)Can you explain me how to create surrogate key in oracle 10g with example. Surrogate key (SK) is not database vendor specific. It is a concept in table structure. SK is merely an unique identifier for each row that can be used as...

Oracle: syntax to add constraint, Constraints
Constraints: Hi Vijay, Reference: http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_3001.htm#i2103997 You can use the ADD, MODIFY RENAME clause as part of the ALTER TABLE syntax when dealing within constraints. The data value must be consistent with...

Oracle: Exceptions in sequence, suchitra, database version
suchitra, database version, sequences: Hi Kavitha, You can find more information of sequences on this site - http://docs.oracle.com/cd/B28359_01/server.111/b28310/views002.htm Or you can search on net for sequences related to your specific database version. Regards Suchitr...

Oracle: oracle, mail id, personal mail
mail id, personal mail, employee id: Hi Radhakrishnan, The query is returning the top 5 employees whom have changed department. The problem is when you have multiple employees who are tied for being in the top n spot. ROWNUM is the easist way to return the n-row results. Otherwise...

Oracle: oracle data types, size constraints, oracle data
size constraints, oracle data, byte limit: Hi Shankara Glad that I can help you. 1) How is it possible to hold 2000 unicode characters in 2000 bytes.because Unicode characters may be multibyte. Answer: You are correct that unicode characters are multibyte, however, NCHAR can store both unicode...

Oracle: oracle data types, oracle data, oracle 10g
oracle data, oracle 10g, multibyte characters: HI Shankara, 1. Maximum lenght of an NCHAR data type in Orale 10g is the upper bound of 2000 bytes or 2000 characters 2. NCHAR: Fixed-length character data of length size characters. The number of bytes can be up to two times size for AL16UTF16 encoding...

Oracle: Pension Plan Types, canadian pension, pension plan
canadian pension, pension plan, customization: Hello Christine, Yes, your IT person is right. There are few customisations (hard coding of plan type) that exists to segregate the USA and Canadian pension plans. Assuming you are going to use the USA pension panels (82 to 87) You will need to modify...

Oracle: Pipeline, table functions, pipeline
table functions, pipeline, sorry for the delay: Hi Smitha, Sorry for the delay. You can find all the info and examples for pipelined functions using these links - http://www.oracle-base.com/articles/misc/pipelined-table-functions.php http://www.akadia.com/services/ora_pipe_functions.html http://www.orafaq.com/node/38...

Oracle: testing to production, Data Center Sizing; Oracle 11g
Data Center Sizing; Oracle 11g: Hi Sultan, 1. Testin on an identical configuration and setup as Production can help to mitigate production go-live issues. However this is normally reserved for a pre-production or back-up (secondary) type environment. For a testing environment, if you...

Oracle: unique key constraint violated, santoshi, primary key
santoshi, primary key, key value: Good day Santoshi, When you have a primary key, it means that this primary key MUST be unique and and cannot be NULL. Having said that, you will need to make sure that (1) the primary key value that you are inserting does not already exist; (2)...

Oracle: Problem with Export Job, oracle database 10g, export job
oracle database 10g, export job, storage disks: Hi Walid, It looks like someone may have tried to launch an Oracle Datapump (http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm) against the database. They may have been trying to load some data or they may be using an application (such...

Oracle: Problem with Job Queue Process, Oracle, J000
Oracle, J000, job queue process: Hi Abdul, You should also look at DBA_SCHEDULER_JOBS as well. While it may not be one of your scheduled jobs, it may be one that was scheduled as a recuring job by your Oracle DBA. Here is the query that you can use when you get that warning again: ...

Oracle: carier guiding in database feild, java software development, software development field
java software development, software development field, oracle sql: Hi Vikas, If you want to go in database field, then better to go in pure database field like Oracle SQL and PL/SQL. You will be able to do programming in this area. If you select Java, there will be very little database activity (only connection, queries...

Oracle: constraint, constraint name, column name
constraint name, column name, cols: Hi Camron, The SQL that you provided in the reply works as expected. I think the reason why you are not getting any result is due to the following (1) The SQL is assuming that you are logging on using the schema owner, i.e., if you want all the constraints...

Oracle: Database reorganization, database reorganization, database organization
database reorganization, database organization, database features: Good day Kumar, You will find the enclosed is a white paper from Oracle to explain the database organization. It is based on 10gR2 http://www.oracle.com/technetwork/database/features/availability/ha-10gr2-online-reorg-twp-131644.pdf Hope it helps...

Oracle: Error at line 0: PL/SQL: Compilation unit analysis terminated, compilation unit, pl sql
compilation unit, pl sql, department id: Good day, I do not have any experience working with APEX SQL command prompt. If I am using SQL Plus, I will be using the follwoing SQL SELECT owner, object_name, pls_type FROM all_arguments WHERE object_name = OBJECT_NAME AND in_out = OUT...

Oracle: Faild transaction issue, Autocommit, SQL*Plus
Autocommit, SQL*Plus, Oracle: Hi Seshu, Unless you have auto-commit enabled (e.g. committing after a fixed number of transactions), then the entire transaction would have rolled back and failed in its entirety. In Oracle s SQL*Plus utility, you can set AUTOCOMMIT (Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12040.htm#i2698639)....

Oracle: Oracle installation, OS Kernel Parameters, Oracle
OS Kernel Parameters, Oracle, Linux: Hi Seshu, http://slashzeroconf.wordpress.com/2008/01/24/how-to-permanently-set-kernel-parameters-for-oracle-on-linux/ provides information on how to permanently keep the configuration (note that should you change the configuration you will need to update...

Oracle: How to partition a large table, small tables, using exchange
small tables, using exchange, million records: Hello Seshu, Please check the following link for more details - http://www.oracle-base.com/articles/misc/partitioning-an-existing-table-using-exchange-partition.php You can check your DB version and search in respective section of this link. ...

Oracle: Partitioning on large, Partition tables
Partition tables: Hi Kumar, 11gR2 Partition Concepts Guide: http://docs.oracle.com/cd/B28359_01/server.111/b32024/partition.htm Without understanding exactly your requirements, here is the syntax you would need to create the partitioned table: http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm...

Oracle: performance tuning of report query, Explain Plan, Performance tuning
Explain Plan, Performance tuning: Hi Suman, You may wish to run your query through an Oracle Explain Plan (reference: 1. http://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm) An Explain Plan is a way by which you can understand how Oracle is processing your query. (Explain...

Oracle: Data Guard, time hope, startup time
time hope, startup time, oracle: Hi Seshu Here is the official explanation from Oracle, and it is pretty much say it all. AFFIRM—specifies that a redo transport destination acknowledges received redo data after writing it to the standby redo log. NOAFFIRM—specifies that a redo transport...

Oracle: Data Guard, orapwd, generic answer
orapwd, generic answer, network bandwidth: Seshu, (1) I have never heard of vanilla DG, but I believe in your context, Vanilla Data Guard is the basic Data Guard option that comes with EE. There is an extra cost option for the Active Data Guard. (2) It is important to understand why you need...

Oracle: Data Guard quary, oracle documentation, log transport
oracle documentation, log transport, standby database: Good day Kumar All you need to do is the apply those log using your backup. Here are the steps - Stop the log transport on the primary - Stop the log apply on standby - Determine the last SCN on the standby database. (current_scn on v$database) ...

Oracle: Data Guard quary, quary, log archive
quary, log archive, fal: Hi Kumar FAL_CLIENT is not long required. If it is not set, the FAL server will obtain the client s network address from the LOG_ARCHIVE_DEST_n parameter that corresponds to the client s DB_UNIQUE_NAME. FAL_Server is still required. Hope it helps...

Oracle: delting the records temporarily in mysql, ROLLBACK, DELETE
ROLLBACK, DELETE, COMMIT: Hi Phani, You may want to try the MySQL groups within All Experts. As far as I am aware, you cannot delete some records temporarily. (reference: http://dev.mysql.com/doc/refman/5.0/en/delete.html) In Oracle RDBMS, when you are in SQL*Plus, you can issue...

Oracle: RMAN, database instance, channel description
database instance, channel description, retention policy: Good day Sechu (1) I don t really know what the default RMAN keep for backup. I always specify my retention policy. I never use the default. Here is some information about RMAN retention policy http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmconc1.htm#i1008093...

Oracle: RMAN, time command, enough space
time command, enough space, disk space: Good day Venkat, My assumption is that part of the backup was completed but some files weren t before it run out of disk space. If that is the case, you can use backup .. not backup since time command from RMAN. Example: BACKUP NOT BACKED...

Oracle: business analyst path, oracle dba, java languages
oracle dba, java languages, computer sci: Hello Aashish, If you are interested in BA career, DBA will not be suitable. You can try development areas like SQL, PL/SQL, Forms, App Servers etc. which have more scope in BA area. Mostly you would need to write queries, analyze and make decisions. Data...

Oracle: business analyst, Career Advice. Oracle, business analyst
Career Advice. Oracle, business analyst, DBA: Hi Aashish, A business analyst (BA) is focused primarily on the business of an organization. There are 4 different areas where BAs can be found int: 1. Strategic Planning. 2. Operational Planning (Business model). 3. Operational Business Process. ...

Oracle: IMPORT TXT FILE DATA INTO ORACLE, oracle table, indian rupee
oracle table, indian rupee, credit staff: Hello Ranadeep, First you will need to create a table with the required fields (preferably master and transaction tables). You will then read the file using UTL_FILE, depending on the column positions, insert the data in respective fields. Do this in loop...

Oracle: error in login, ORA-12560: TNS:protocol adapter error, ORA-12560
ORA-12560: TNS:protocol adapter error, ORA-12560, 12560: Hi Sarah, The problem is your database instance is probably not up and running, hence why you are unable to connect. This is a common problem associated to the Oracle error message ORA-12560: TNS:protocol adapter error The solution: a) Start the database...

Oracle: PL/SQL, pl sql, error records
pl sql, error records, error logs: Hello Gaurav, You can achieve this by using AUTONOMOUS_TRANSACTION. Autonomous transactions will only commit the data for which procedure autonomous_transaction pragma is given and commit is given in that procedure. Try your pl/sql block as follows -...

Oracle: RMAN, minimal transaction, transaction activities
minimal transaction, transaction activities, database instance: Good day Gaurav, When I encountered this problem last year (one of the staff using the wrong script accidentally updated the wrong table in production from the backend), we restored the RMAN backup to another database instance, and then copy the data over...

Oracle: scn, udit, depth knowledge
udit, depth knowledge, blogspot: Hello Udit, I don t have any in-depth knowledge in this area, but you can check the following links - http://oracledbascriptsfromajith.blogspot.com/2009/05/understanding-scnsystem-change-number.html http://orainternals.wordpress.com/2012/01/19/scn-what-why-and-how/...

Oracle: dynamic queries, Query and Subquery
Query and Subquery: Hi Josh, Here s a re-write of your code in question: select A.errormessage , A.main_count , B.onetwoone_count from (select C.errormessage, count(C.errormessage) main_count from javascripterrors C group by C.errormessage...

Oracle: Executing a formulae in a field, record id number, bill of quantities
record id number, bill of quantities, height values: Hi Natraj What I will suggest you is to do the following: (1) Update the create script above to change the CALCULATION column be VARCHAR2(50). This column will store the formula in which the user will enter CREATE TABLE ECEBI . FIRST_RECORD ...

Oracle: Executing a formulae which is in a field, Executing a stored procedure
Executing a stored procedure: Hi Natraj, To execute a stored procedure from within Oracle s SQLPLUS, you can either use: SQL execute my_store_proc (var1, var2, ... var x) where var1, var2 ... var x dependes on the number of variables that the stored procedures requires and it...

Oracle: about oracle, oracle concepts, oracle sql
oracle concepts, oracle sql, pl sql: Hello Prashant, Oracle DBA is a good area. But first you have to learn the basics of Oracle, SQL, PL/SQL etc. Once you get the oracle concepts, you can go ahead with some dba activities, gain experience and keep on trying new features. This way tou can...

Oracle: Oracle DBA, Oracle Training for DBA
Oracle Training for DBA: Hi Prashant, First and foremost, you must have a very strong understanding of the concepts and practical proficiency with Oracle SQL (including PL/SQL). It s not just about writing queries but also understanding how the Oracle optimizer will interpret it...

Oracle: PL/SQL, oracle optimizer, blob data
oracle optimizer, blob data, optimal execution: Good day Gaurav 1)In what case hint is helping and in what case it is reducing the performance for a query? There are scenarios that Oracle optimizer did not create the optimal execution path to retrieve the data. HINT allows you to overwrite Oracle execution...

Oracle: Sql Query, suchitra, formula x
suchitra, formula x, select statement: Hello Natrajan, You can evaluate the formulas this way in Oracle 11g version, by using function-based virtual columns as below - create table tab1 ( x number, y number, formula generated always as ((X*Y)/2+Y*2)); insert into tab1 (x,y) values...

Oracle: table size is increasing abnormally, business users
business users: HI Kumar, If your table is being used as a temporary table to store values, then it s possible that it can grow quickly. You need to understand the application that is using the table to understand why the sudden growth. If the table continues to growing...

Oracle: unique constraint voilated, constraint name, constraints
constraint name, constraints: Hi Shailendra, Please see the results of following query for the exact constraint_name which is disabled. select table_name, constraint_name, status, validated from user_constraints where constraint_name = yourconstraintname ; If the status is disabled,...

Oracle: DBA 10g, Junior Oracle DBA Interview Questions
Junior Oracle DBA Interview Questions: Hi Mohammed, As a 1st time junior DBA, you can expect many technical questions. In Sureshgandhi s blog (http://oracle-info.com/dbahelper/junior-dba-interview-questions/), he identifies a number of good questions on - Database structurs - Memory Management...

Oracle: performace problem while processing only 11lacs record, detail count, table detail
detail count, table detail, header table: Hi Reader, I am not sure what is your exact problem and expectation. But you can try the FORALL feature of Bulk Collect (instead of for loop). For more info on Performance tuning you can check the below link and use the appropriate method - http://docs.oracle.com/cd/E11882_01/appdev.112/e17126/tuning.htm#i52932...

Oracle: Oracle HRMS for Education Domain., Oracle, Education
Oracle, Education, HRMS (Human Captial Management): Hi Prashant, 1. Education and Training services may be better served may be better to use the PeopleSoft Campus Solution (for higher education) rather than using the HCM/HRMS modules. This is because the HCM/HRMS is primarily used for human resource mananagement,...

Oracle: QUERY PLAN, Oracle, Optimizer
Oracle, Optimizer, Statistics: Hi Gaurav, Starting with Oracle 9i, Oracle recommends that the database optimizer be set to COST Based (the alternate was Rule base which since 10gR2 is no longer recommended). The COST based optimizer uses database statistics to generate the execution...

Oracle: Printing date
Hello Navin, Sorry for the late reply. I think you are using SQL Server and not Oracle. Hence I am not so sure about the DateAdd function. But you can check this link which will help you in displaying the date as well as the week number (ww). http://www.mssqltips.com/sqlservertip/2509/add-and-subtract-dates-using-dateadd-in-sql-server/...

Oracle: Error during Analyzing table
Hello Krishanu, Check the following links which might resolve your problem - http://stackoverflow.com/questions/14624650/exec-gather-table-stats-from-procedure http://www.oraclealchemist.com/news/when-errors-tell-you-absolutely-nothing/ Hope this...

Oracle: Oracle 12c, Oracle 12c, Concepts
Oracle 12c, Concepts: HI Nelson, CDB = Container Database (within a multitenant environment) PDB = Pluggable Database (source: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89234) In Oracle 12c, the multitenant architecture enables an Oracle...

Oracle: UTL_SMTP
Hello Gaurav, You can try utl_Smtp in loop with a pl/sql block with exception handling, instead of adding all the addresses in TO field. You can check the following link which might help - https://community.oracle.com/thread/1125736?start=0&tstart=0...

Oracle: spatial database, GIS, Oracle Spatial
GIS, Oracle Spatial, Spatial: Hi Kim, The two works hand in hand. The two being the Oracle Spatial (RDBMS) and the GIS software s database (geodatabase). A multiuser geodatabase utilizes a multitier architecture that implements advanced logic and behavior in the application tier...

Oracle: plsql
Oracle: plsql

Oracle: plsql
Hello Prakash Kumar, Try one of the following - stmt varchar2(200) := select * from employees ; ---- space after table name OR stmt := stmt || where DEPARTMENT_ID = :v_deptno ; ---- space before where condition If it still does not work,...

Oracle: Insert, Duplicate rows
Duplicate rows: Hi Gaurav, You need to use an inner-join query to pull out the duplicate records and get some decisions about (a) removing the duplicates; of (b) create new entries for the duplicate (so that their entries are unique). This depends on the business rules,...

Oracle: Addendum to My Last Question
Hello Liz, Sorry for the late reply. I have not worked on Forms for a long time now. But I will try. I am assuming that SZBXUNI is a block? Try to comment the statement :SZBXUNI.SZBXUNI_FIELD1 := 9876533; and then run form. Check whether you...

Oracle: import problem, Import, unique constraint
Import, unique constraint: Hi Fahmida, The problem that you are encountering is you are attempting to import a row of data that is causing the Primary Key (PK) index, sysMAN.MGMI_ARU_PRD_PK to fail. As it is a PK, it is expecting unique values. It is possible the DMP file for...

Oracle: 3 - Doubts?, forms6i, oracle 9i
forms6i, oracle 9i, oracle database: 1) Use the HOST builtin lv := %%x; E.g :HOST( ifcmp60 || lv || username/password@host ,no_screen). 2)No idea. 3)SQL loader : user can load external files to oracle database using sqlloader. When the time of installation,it also includes...

Oracle: how 9i OMS deal with 8i/10g agent, oracle management server, oracle enterprise manager
oracle management server, oracle enterprise manager, oracle db: Hi Steven, You ll need to read up on Oracle 10g s Grid Control and Oracle Enterprise Manager. http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-09-25.4346421276 http://www.orafaq.com/node/26 http://www.orafaq.com/search/oracle+management+server...

Oracle: Access DB move into Oracle, oracle odbc driver, data source name
oracle odbc driver, data source name, odbc link: HI there, It may be easier to re-create the table structures in Oracle, and then using the ODBC connection, copy the data to Oracle. You should first setup your ODBC link to Oracle. On a Windows 2000 machine, go to SETTINGS | CONTROL PANEL | ADMINISTRATIVE...

Oracle: Access DB move into Oracle, hp number, load data infile
hp number, load data infile, odbc connections: Hi, Open the MS-Access Table. 1. Click File - Export 2. Choose Save As - Text Files 3. Choose Comma Delimited File 4. It will store as a comma delimited flat file C:INFO.CSV(Comma Seperated file) Now use SQL Loader to migrate from flat...

Oracle: Access Tables of other user, schema name, synonym
schema name, synonym, syntax: Hi Nabyendu, One easy way of accessing user SCOTT s schema is to prefix the table name with the schema name. Thus if user SCOTT owns a table called DEPT then you can use SCOTT.DEPT e.g. SELECT * FROM SCOTT.DEPT; Another way, is to create a public...

Oracle: Account Expiry., login attempts, expiry date
login attempts, expiry date, life time: Hi Gireesh, It s not exactly an expiry date, but you can expire a password after xx days through the use of PROFILES: EXAMPLE: CREATE PROFILE prof LIMIT FAILED_LOGIN_ATTEMPTS 4 PASSWORD_LOCK_TIME 30 PASSWORD_LIFE_TIME 90; ALTER USER...

Oracle: Admin Database, software test engineer, command line argument
software test engineer, command line argument, data migration: Hi Rashmi, You can test it by being an end-user. The DB upgrade and subsequent data migration to the new DB should not affect the performance and access to your portal/application. The positive test would be does every work the way it did before the upgrade....

Oracle: Advanced SQL., retrieval examples, oracle university
retrieval examples, oracle university, set operators: Hi Mark, These functions are specific to the generation of business intelligence results set that can then be used an an OLAP (On-line Analytical Process) application (e.g. Cognos PowerPlay, etc.). http://databases.about.com/od/sql/l/aacuberollup.htm...

Oracle: Advise on Career, oracle database administration, computer science graduate
oracle database administration, computer science graduate, ocp dba: Hi, Oracle database administration is a very high profile job. But to gain knowledge on this, you should first have a good experience on Oracle developer skills. You can start learning DBA side by side. You should try all the DBA activities on your personal...

Oracle: Alter Or Drop Global Temp Table, varchar2, temp table
varchar2, temp table, using oracle: Hi Kiran, Using Oracle 10gR2: SQL create global temporary table gtt_table 2 (col1 integer, col2 varchar2(1), col3 varchar2(1)) on commit delete rows; Table created. SQL commit; Commit complete. SQL drop table gtt_table; Table...

Oracle: Alternate login to remote DB using sqlplus, oracle home, oracle client
oracle home, oracle client, oracle sql: Hi Parag, $ORACLE_HOME/bin/sqlplus /@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SID=))) After @ what ever is written that is the host details which you are passing at the time of...

Oracle: Analyzing Partitions, oracle 9i database, batch processes
oracle 9i database, batch processes, cascade: Hi John, You might wish to refine your DBMS_STATS to tune it to your requirements. If your performance is still acceptable after running the DBMS_STATS, I d leave it as it is for now. Likewise, if the DBMS_STAT is taking too long to run (i.e. is impacting...

Oracle: Application hangs when user navigates across multiple forms, multithreaded java, browser memory
multithreaded java, browser memory, java issue: Hi, This almost sounds like there s a java issue than a locking issue. When you re just navigating a form, you re not writing anything to your application database. You are if you have filled in the form AND saved the data. If you re just filling in the...

Oracle: Automated guaranteed backups ... 10g, rman oracle, oracle 10g express edition
rman oracle, oracle 10g express edition, dos command line: Hi Rohit, RMAN, like the EXPort, is a tool that you can use. You will still need to write some scripts (batch or using a scheduler) to trigger the backup to run. Enclosed are some reference links: Oracle® Database Backup and Recovery Quick Start Guide...

Oracle: Avoiding hardcoding column names, data dictionary, column names
data dictionary, column names, number 1: Hi Melissa, You can use the INSERT statement that incorporates a select, thus insteading of doing two actions (1. Select the values you want, and 2. inserting them into a table) you can try something like this: INSERT INTO TABLEB (SELECT insert...

Oracle: adding a extra column onto a query, birth town, mature students
birth town, mature students, two answers: Hi there The problem is that you will have a a column with the same value along all the result: select b.*, (SELECT COUNT (*) Total No Of Mature Students FROM Student Where DOB = 31-AUG-81 ) Total from ( ...

Oracle: additional columns in a GROUP BY query, employee group, time steve
employee group, time steve, line 1: Hello, You can write a SQL*Plus report like this set pagesize 66 set linesize 80 col emp_id format 99999 col name format a30 col position format a20 col salary format 999999.99 break on position skip 1 on report compute sum of salary on...

Oracle: analytical func, analytic function, sum function
analytic function, sum function, func: Hi, On an outset any function that can help you make analytic decision would be an analytic function. However its the way u use them that makes all the difference. For instatance a simple sum function is an analytical function. it gives u the sum, but its...

Oracle: Did you ever get an answer to this queston?, c oracle, pfile
c oracle, pfile, auto shutdown: Hi Luke: set heading off select case when count(*) = 0 then Database started using PFILE(init.ora) else Database started using SPFILE. end from v$spparameter where isspecified = TRUE and rownum = 1 / set heading on select...

Oracle: about antigrity, normlization,..., data integrity, emale
data integrity, emale, primary keys: Hi Imran, Data Integrity refers to the fact that your data is consistent. For example, if you have a PERSON table and a column SEX, you can only have the values M(ale) or F(emale). Users cannot insert other values into this column. This type of enforcement...

Oracle: how to avaoid mutating error?
Hi, Mutating occurs when u are trying to update/delete the same table on which the trigger is based. If you want to update any column in the same table, just assign the value to the new variable - eg :new.fld1 := xxx ; Regards Suchitra ...

Oracle: Backup, dbf files, html details
dbf files, html details, database note: Hi Shinil, What you are doing amounts to what Oracle would call a COLD BACKUP . Essentially, it s taking all the important files that are necessary to restore the database. Enclosed is a link that details exactly what files you would need from the...

Oracle: Backup, performance impact, seema
performance impact, seema, cpu cycles: Hi Seema, In general, when you enable compression, there is a performance impact on system resources (in this case additional CPU cycles are required to compress the data in an EXP and to decompress the data in an IMP). The advantage of the compression...

Oracle: Basic difference between Oracle 9i and 10g, oracle 9i, server 101
oracle 9i, server 101, flashback: Good day Ranvijay There are a lot of differences and enhancement between Oracle 9i and 10g, for example, flashback funtionality and rolling upgrade using Data Guard to name a few. There are so many that it is very difficult to list them all here. ...

Oracle: Calculate time scale difference, time scale, yyyy
time scale, yyyy, jasmine: HI Jasmine, You might want to change the column from a NUMBER(4) to the datatype DATE. This way you can use DATE artithmetic (Oracle s default date format is DD-MON-YYYY. You can change it to display DD-MON-YYYY HH24:MI:SS using the ALTER SESSION SET NLS_DATE_FORMAT...

Oracle: Calculate time scale difference, time scale, jasmine
time scale, jasmine, desc: Jasmine, Can you please provide me with more inputs: 1. What does standard_start and standard_stop values hold. Do they hold the elapsed time in secs, mins, etc 2. If difference between 2100 and 400 = 7 hours, what is is the difference between 1600...

Oracle: Capacity Planning, oracle, docs
oracle, docs: Hi Vikas, Here s a great article that walks you through the steps involved with capacity planning for a database. http://www.databasejournal.com/features/oracle/article.php/3673616 http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/schema008.htm...

Oracle: Career., microsoft sql server, legacy databases
microsoft sql server, legacy databases, oracle databases: Hi Mark, I acutually started off my career working with some legacy databases (some hand me down applications that I was taking over). later moved to Sybase and Microsoft SQL Server and then fianlly to Oracle 7. My intro to Oracle 7 was fortunate as I was...

Oracle: Changing Password., sqlplus nolog, tiger account
sqlplus nolog, tiger account, sid c: hello there is no way u can get system password thru scott till the time scott does not have the DBA priv. one thing what u can do is provided u have o/s as windows and 9i release 1 u can do the following and u have logged in as an o/s user who has...

Oracle: Clone PeopleSoft 8.8 Oracle DB, demo databases, oracle db
demo databases, oracle db, peoplesoft 8: Hi Wenjia, Cloning the 8.8 database still follows the procedure for a 7.5 database. That does not change. You will have to setup th PIA using the old userid and password. You will have to change the report manager settings and integration broker (if...

Oracle: Cloning database, clone database, oracle 9
clone database, oracle 9, database files: Hi, There a various ways to achieve this: 1. Make an export of the schema(s) you want, create a new database and then import the schema(s) (easiest option I reckon) 2. Copy the existing database files to another directory, then create a seperate init.ora...

Oracle: Collection, array type, distinct values
array type, distinct values, duplicate records: Hi Amber, There is one function called SET(collection_name) for removing duplicates from your collection. Add the follwing code in your procedure just after the main Begin strats. Hope this will solve your problem. begin if pi_acc_no.count 0 then...

Oracle: Command Line, oracle commands, windows command
oracle commands, windows command, sql script: Hi, From a command line, if you want to connect and execute a SQL script, say MyCode.sql the syntax on Unix and Windows would be (same syntax): Shell sqlplus user / pw @ db @MyCode.sql Where user and pw represent your user and password respectively;...

Oracle: Comparing two versions of a database columns, database versions, database link
database versions, database link, db link: Hi Linda, You can setup a database link from DB version 1 to DB version 2 (or vice-versa). You want to set one up in the database where you will run the query. To learn how to create a database link: http://www.ss64.com/ora/link_c.html You can use...

Oracle: Configuration of a DB, oracle 9, disk allocation
oracle 9, disk allocation, time constraints: Hi Alonso, The Oracle database, with sufficient disk allocation (usually via a SAN-Storage Attached Network device) is capable of storing the number of records indicated. So the question that I have, what is the business requirement that requires 6...

Oracle: Connection, odbc connection, oracle environment
odbc connection, oracle environment, oracle database: Hi Subangini, The easiest way is to configure an ODBC connection for Oracle is through this tutorial (It s for Windows Server 2000 but is accplicable also for Windows XP) http://www.simongibson.com/intranet/odbc/ If you are missing drivers for your Oracle...

Oracle: Conversion Functions., oracle 9i, conversion functions
oracle 9i, conversion functions, server 101: Yep: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/toc.htm (Not much changed in TO_DATE, TO_NUMBER and TO_CHAR though...:-) Note that ALL 9i manuals, references and guides are available at: http://www.oracle.com/pls/db92/db92.docinde...

Oracle: Copying Oracle Database, oracle 8i, target database
oracle 8i, target database, oracle database: HI Ishola, You can either backup the Source database using EXPORT to produce an Oracle .DMP file. This can be IMPORTed to your target database on your local machine. This assumes that you ve installed Oracle and created an instance on your local machine....

Oracle: Create PL/SQL PROCEDURE, sql procedure, pl sql
sql procedure, pl sql, annual salary: Hello Jawad, Try this query select empid, last_name, first_name, sal*12 annual_salary, case when sal*12 = 6000 then 0 when sal*12 between 6001 and 25000 then 0.15*(sal*12...

Oracle: Create Table, application error, select count
application error, select count, pk: Forgive me! There were errors in the code. Here goes the right version: create or replace trigger row_limit before insert on TAB1 declare v_cont number; begin select count(*) into v_cont from TAB1; ---Limit for 8 rows for example...

Oracle: Create TEMP Table dinamically, table definitions, checkdate
table definitions, checkdate, meta data: Hi Diego, I am assuming that the meta data for the temp table that you have to create dynamically contains all the necessary information to construct the table. If it s missing any information, then it will either have to be hardcoded or the meta data needs...

Oracle: Creating a Database, oracle 8i, using oracle
oracle 8i, using oracle, yyy: Hello, I did not get your first question. Regarding second, you can create another user in oracle using the create user command as follows create user xxx identified by yyy; where xxx is new username and yyy is password. Then you can login...

Oracle: Creating a Database, oracle 8i database, sid c
oracle 8i database, sid c, oracle services: Hi there. 1. Create Oracle 8i database: CREATING THE INSTANCE AND SERVICES 8.1 ====================================== 1. Using the command line version of Instance Manager to create the new NT Services. a. Change to the oracle_home in ...

Oracle: Creating extract files and developing reports, comma delimited format, oracle general ledger
comma delimited format, oracle general ledger, property casualty company: Hi Tim, Extractions are very easy - You can write SQL/PLSQL code to produce comma delimited format, or any thrid party (e.g. SQR, C, etc.). I just did a quick search on google.com with the key words DATA EXTRACT and DATA TRANSFORMATION and came up with...

Oracle: Creating a script file to run a report., unix command line, sql report
unix command line, sql report, powerpoint slides: Hi Mark, A script file on Windows can be created using Notepad or any non-gui based text editor (It is better to use a text editor than say MS-WORD). The scripts should be stored with a .SQL extension. That way you know that it s an SQL. On Unix, you...

Oracle: Creating user identified externally, uk oracle, server 101
uk oracle, server 101, base documentation: Good day, There are several things you will need to setup the database and the operating systems so that it can be authenticated. Here are two helpful examples link and step-by-step instruction for your review. 1. Oracle-Base documentation on how to...

Oracle: Creating users, oracle accounts, optional command
oracle accounts, optional command, temporary tablespace: Hi, The syntax to use is: ... denotes user supplied information. [...] denotes optional command (recommended best practice) create user username identified by password [default tablespace user_tablespace ] [temporary tablespace temp_tablespace...

Oracle: Curing an ORA-04091 mutating trigger error, sql code, many thanks
sql code, many thanks: andy i have again gone thru ur senario and have realised that u have 2 tables PO_HEADER and PO_DETAIL lets assume when u update the date in the PO_HEADER u want that date to be reflected in the PO_DETAIL table. if i m right then what u can do is create...

Oracle: Custom PL/SQL Statement, oracle discoverer, pl sql
oracle discoverer, pl sql, sql statement: Hello Lorinna u dont need to bother whether u sound stupid, coz what i believe is no one is born expert, instead one need to work hard and learn to be one and i m glad u r doing that by asking questions, coz it shows u want to learn. i m not an expert...

Oracle: call procedure from trigger, tbl, key word
tbl, key word, pls: hello michael EXEC is used from the command line, u dont have to use EXEC to call a procedure. begin pkg.proc(:new.tbl_id, other ); end; no need for exec or any other key word just call the procedure as PACKAGE_NAME.procedure_name but if...

Oracle: calling a function inside a select statement, select statement, dml
select statement, dml, rollback: U can t commit within a function. the function will compile but u get error at run time like this cannot perform a DDL, commit or rollback inside a query or DML but if u commit after the return statment it will compile and execute but the COMMMIT...

Oracle: car rental database, credit card insurance, rentee
credit card insurance, rentee, rental database: Hi Emily, That depends on your requirements. If I assume that I own a car rental facility, then my requirements would be to track the cars that I own/lease. I may also wish to include a rental database to track who is renting my vehicles. My car tracking...

Oracle: career in dbms, prerequisite skills, career aspects
prerequisite skills, career aspects, oracle 11i: Hi Isha, You can look for co-operative experience or any volunteer work or employment with smaller organization/companies to gain experience. As a DBA, you will have to demonstrate that you can: a) installation and maintenance of Oracle Software ...

Oracle: with check option constraint, check constraint, check option
check constraint, check option, column data: Hi Mark, this constraint checks the condition specified on a column whenever you do an insert/update to that column data. For ex, if I have a column salary and have specified a with check constraint to check that salary should be greater than 2500, then...

Oracle: choosing a careear, telecommunication specialist, choosing a career path
telecommunication specialist, choosing a career path, careear: Hi Pradeep, With your background, whichever you choose, you will make use of your gained knowledge. Working as an Oracle DBA, having Network Telecomm knowledge is an asset. Working as a netwrok Telecomm specialist, you don t necessarily need to know...

Oracle: How to communicate different schemas in different instances of the Same Database ?, schemas, schema
schemas, schema, clarification: Hi, I didn t get your question clearly. You can communicate with different schemas by specifying username . tablename provided you have privilege on that table. If it is on another database means you can accomplish this by db links. If you still have...

Oracle: conf. OEM (Oracle 9i Client), firewall configuration, tnsping
firewall configuration, tnsping, oracle 9i client: Hi Kate, Is the OEM installed on your laptop or are you trying to access the WEB-based version of OEM? It s possible that your VPN/firewall configuration is not allowing the web-based http traffic fromthat port on the server to your laptop. Pete...

Oracle: conn / as sysdba, safe side, conn
safe side, conn, two steps: Hi Sameer, ON the safe side, I always set my ORACLE_SID parameter as well as specify the database which I would like to connect to. Thus when at a SQLPROMPT, I issue the command: SQL conn user / pass @ dbname as sysdba; or break it into two steps,...

Oracle: to connect to remort server, oracle client, oracle 9i
oracle client, oracle 9i, client drivers: Hi there, on your remote client, you will need the Oracle Client (http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html) and to update the TNSNAMES.ORA file that will enable you to connect to the remote server. The contents of that...

Oracle: connect as sysdba, 01031 insufficient privileges, system privileges
01031 insufficient privileges, system privileges, svrmgrl: Hi Halie, The connect as sysdba works from a command line within SVRMGRL (which is no longer supported). You should be able to do what you need to do as SYSDBA using the SYSTEM account. I normally recommend DBAs to create a new user and assign the...

Oracle: What is correlated subquery?, blah, blogs
blah, blogs: In SQL, a query that cannot be evaluated independently, but that depends on the outer query for its results. The inner query has to be repeated once for each row that the outer query returns. These drive some simple-minded SQL engines insane. - source:...

Oracle: What is correlated subquery?, column name, table column
column name, table column, optimizer: Hello, In a correlated subquery, the inner query uses information from the outer query and executes once for every row in the outer query. This correlation is accomplished by using a reference to the outside query within the subquery. The use of a correlated...

Oracle: Can we create a foreign key based on a view ?, disucssion forum, foreign key
disucssion forum, foreign key, oracle: Hi there, Yes you can but there are some contraints as to what you can or cannot do. Enclosed is a reference in a disucssion forum where someone ran into a similar problem: http://www.thescripts.com/forum/thread64610.html Here s an interesting article...

Oracle: create new user, hr assistant, new member
hr assistant, new member, privileges: Hi You can create a new user in Oracle by using the CREATE USER username IDENTIFIED BY password ; You then have to grant the user access to certain tables. The user should be granted one of or combination of SELECT/INSERT/UPDATE/DELETE privileges...

Oracle: Can we create a schema such as user1, but without a user by that name?, user schema, typical user
user schema, typical user, user1: Hi there, To create a schema in Oracle, it has to be associated with an Owner (typically it s a user). That user does not have to have the same priviledge as the your typical user, just enough to be able to share access to its tables. For example, I...

Oracle: creating a car rental database, mail id, oracle 9i
mail id, oracle 9i, rental database: Hi kathy, My sincere regrets for late reply. Could you please send me zipped design documents so that we could discuss it further and create the database. send me the documents at following mail ID bhupendra.kapure@morganstanley.com Also please tell...

Oracle: creating columns & deleting tables, oracle sql, oracle 9i
oracle sql, oracle 9i, temp table: Hi Reniet, 1 - Adding an extra column can be done in two ways. Prior to Oracle 8i, you would have had to copy the data to a temp table, drop the table, re-create the table and move the data from the temp table back in. With Oracle 9i and higher, you...

Oracle: creating database, pool memory
pool memory: First give your detail.When will occur,etc. 1)This may be index problem. 2)May be the database shared pool memory pblm 3)may be network pblm. So please give detail when will it occur.Based on that only i can give solution to you. Thanks Sara...

Oracle: creating table on sql, number 0, application error
number 0, application error, pk: Hi Ash, Limiting no of rows in a table is difficult. I am not so sure. But you can try writing a procedure which counts the number of rows in that table and call it before inserting. eg. create or replace procedure check_rows (p_tab in varchar2, p_maxrows...

Oracle: creation of new database in already running server, listener log, oracle service
listener log, oracle service, oracle 8: Hi, There is nothing different in creating a new database on a server as when you created the first one. You must just give it a unique name (other than existing databases on the same server), add an entry in the listener.log file and restart the listener,...

Oracle: creation of new database in already running server, oracle software, oracle 8
oracle software, oracle 8, database instance: HI Hari, When you create a database instance, you are creating the phsyical files required by Oracle. These files allow you to host one or more database. Typically, DBAs prefer one databast instance to one database. It makes for easier management. To...

Oracle: D2K, sqlerrm, kalpesh
sqlerrm, kalpesh, samed: Kaplesh, Can you please check the error code. I belive the Oracle Code have this format ORA- followed by 5 digit number. Ex: ORA-06512 SQL SET SERVEROUTPUT ON SQL EXEC DBMS_OUTPUT.PUT_LINE(SQLERRM (-06512)) Thank you Regards, Abdul Samed...

Oracle: Data porting from Excel To Oracle, oracle database, microsoft excel
oracle database, microsoft excel, oracle: Hi, You ll have to provide some more information here - What kind of problem is it exactly you are facing ? As an inspiration you could have a look at: http://forums.oracle.com/forums/thread.jspa?threadID=305918&tstart=0 or: http://www.sharewareriver.com/products/25553.htm...

Oracle: Databackup, tom kyte, ace expert
tom kyte, ace expert, oracle databases: Hi Shashank, Incremental back up is available with tools from Oracle. If you are using ORacle 10gR2, then RMAN is delivered with RDMS software. http://www.databasejournal.com/features/oracle/article.php/3439441 There are some thrid party commercial...

Oracle: Database, mail server, mr parker
mail server, mr parker, last question: hello shahida sorry about the delay , my mail server seems to have some probs, infact i havent got ur last question details mailed to me yet. coming to ur first question if possible try to do the EXPORT with COMPRESS=N, this shud sort out the issue...

Oracle: Database disconnects, oracle 9i client, oracle library
oracle 9i client, oracle library, oracle 10g database: Hi Wade, Based on your list of errors, there are two possible causes: 1. Network problems. You may have an unstable network or communications that may be colliding at the network level. This may occur if you are, for example, doing a large file transfer...

Oracle: Database Script, new sid, oradim
new sid, oradim, oracle 9i: u mean u want to create the same database with same tables and data in the other os, and what is this os i mean is it windows prof only , if yes then the best thing is to follow the steps below. install the oracle on the other machine. and shutdown ur...

Oracle: Database setup, oracle installation, configuration wizard
oracle installation, configuration wizard, database setup: Using the Oracle installation and configuration wizard (Windows), it will generate a database for you. If you want to create the database manually, the steps can be found on www.orafaq.com - the creation and sizing of each database is generally unique. ...

Oracle: Database setup, oracle library, oracle 8
oracle library, oracle 8, database oracle: Hi Sanfour, You need to use the Oracle 8.0.3 client install or upgrade your client to match that of your back end database. For example, if you ve installed Oracle 8.0.5., you have to use the Oracle 8.0.5 client in order to get the matching OCI.DLL. They...

Oracle: Database updation, unix shell scripting, oracle dbms
unix shell scripting, oracle dbms, unix cron: Hi Bubu, What you are talking about is an automated batch process. For this discussion, I assume that your code to perform the work, in this case, for example, it s a process to pay out interest to accounts monthly. Let us assume that your code is written...

Oracle: Database updation, sql procedure, pl sql
sql procedure, pl sql, database job: Hi Babu, For database job scheduling, you can use the dbms_job package. Following is the syntax to schedule a job through DBMS_JOB DBMS_JOB.SUBMIT ( job OUT BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE DEFAULT sysdate,...

Oracle: Database versioning, application change management, library check
application change management, library check, quest software: Hi there, You may be looking for a product such as STAT from a company called Quest Software (http://www.quest.com/application_change_management/stat_oracle_e-business_Suite/). This product (there may be others as well) allows developers to keep versions...

Oracle: Database up vs Instance running, pmon, database command
pmon, database command, database status: Hi Deepak, That is correct. Some more info about the ORATAB file: http://orafaq.com/faq/what_is_oratab_and_what_is_it_used_for. The Oratab can be used to auto start databases as well as cycling through to backup each database on a given server. If you...

Oracle: Databases and lack of research, third party tools, database papers
third party tools, database papers, oracle forms: Hi Jenifer, While most database papers tend to fall on the side of optimized searches (no surprise there) or storage (Oracle and IBM s products are competeing who can push their database to be able to handle large volume of data), it s interesting to see...

Oracle: Date, dynamic sql, time component
dynamic sql, time component, santosh: Hi Santosh, Oracle s display default is DD-MON-YYYY. Their date field generally includes a timestamp component as well. Thus if you inserted just a date, say 12-DEC-2006, Oracle will assume the time component to be 00:00:00 (midnight). Hope this helps....

Oracle: DB Connectivity Problem, jaswinder singh, connectivity problem
jaswinder singh, connectivity problem, datafiles: ORA-01033: ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while Oracle is being started up or shutdown. Action: Wait a few minutes. Then retry the operation. Try to see if your datafiles are ok. Regards... ...

Oracle: DBA, oracle users group, oracle systems
oracle users group, oracle systems, network with your peers: Hi Prakash, I am assuming in Oracle field you were looking at being a DBA. There s no substitute for actual work experience. If you are able to work in that field you will also be able to learn on the job. Most copmanies usually have a mentor that...

Oracle: What is the DBMS_DESCRIBE package used for?, name translation, pl sql
name translation, pl sql, orap: Hi Izzz, You can use the DBMS_DESCRIBE package to get information about a PL/SQL object. When you specify an object name, DBMS_DESCRIBE returns a set of indexed tables with the results. Full name translation is performed and security checking is also checked...

Oracle: What is the DBMS_DESCRIBE package used for?, dbms output, type num
dbms output, type num, argument name: Hi, You can use the DBMS_DESCRIBE package to get information about a PL/SQL object. When you specify an object name, DBMS_DESCRIBE returns a set of indexed tables with the results. Example -------- CREATE TABLE numtype_codes ( type_num NUMBER(3),...

Oracle: is there any way to run oracle enterprise edition on win98, oracle 8i, oracle enterprise
oracle 8i, oracle enterprise, oracle 9i: Hi, It s not recommended to install Oracle 8i Enterprise Edition on Windows98. The Enterprise Edition can be installed on NT or another MS-Windows Server. The EXE for Oracle 8i are no longer being distributed by Oracle. They do have single user versions...

Oracle: Dedicated Server., dba oracle, server connection
dba oracle, server connection, multithreaded: Hi Mark, http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm http://www.adp-gmbh.ch/ora/concepts/dedicated_server.html http://orafaq.com/faq/how_does_one_set_up_a_dedicated_server_connection Hi Mark, Hope the above three links helps...

Oracle: Delete DUP Rows, component type, column type
component type, column type, sql query: Hi, Check the SQL Query first through SQL*Plus. If it does not give any error, check the columns in the table for dups and the columns in the query. They should match. While inserting what is the error given? Please give me more details after checking...

Oracle: Deleting multiple rows, single line, pl
single line, pl: hello narayan what u can do is have a procedure some thing like this create or replace del_proc is begin delete emp; delete dept; delete salgrade; commit; end; multiple deletes cannot be done from a single line statement. if u looking...

Oracle: About Design in PLSQL, dynamic sql, pl sql
dynamic sql, pl sql, truncate table: Hi, 1) You can use the truncate table or delete table command in PL/SQL. But this is to be executed using Dynamic SQL (eg. execute immediate truncate table tablename ;) 2) This can also be done using Dynamic SQL by creating SQL statements with where...

Oracle: Development database, production databases, production database
production databases, production database, database production: Hi Vikas, Your development database is where you allow your developers to develop their applications and SQL and to test it out. If you lose your development database, you generally just rebuild it. Your production database is where your end-users will...

Oracle: Diff between count(1) and count(*), null values
null values: Hi Deen, According to my knowledge, there is no difference between count(1) and count(*). Both give the same number of rows in a table. As far as performance is concerned, there should not be any difference. But you can try using explain plan for both count(1)...

Oracle: What is Diff.between Procedure..., business logic, error function
business logic, error function, table values: Hello, Bot functions and procedures can return values. Apart from this following are the differences 1) Functions are used for computations where as procedures can be used for performing business logic 2) Functions MUST return a value, procedures...

Oracle: Difference between Access and Oracle, ms sql server, sql language
ms sql server, sql language, access sql: Hi Andrew, You ll probably find MS-SQL Server is somewhat similar to MS-Access. SQL Server and Oracle are enterprise database capable of support a large number of concurrent users and processes. MS-SQL Server is best for small-medium sized bsuniesses while...

Oracle: Difference b/w oracle 9i and 10g?, graphical user interface, based user interface
graphical user interface, based user interface, oracle 9i: Hi Vijay, http://www.orafaq.com/faq/features_introduced_in_the_various_server_releases The above link shows some of the major features in each release. A database is a repository of information (usually data). HOw you choose the database will dictate...

Oracle: Difference between Function and Procedure, oracle function, return images
oracle function, return images, sql statements: Hi, Some of the differeneces are mentioned below Function - 1) Have to return a single value to the calling program 2) Can call functions in sql statements 3) Cannot return images Procedures - 1) Do not return any value except assigning values...

Oracle: Difference between oracle 9i and 10g database object., oracle 9i new features, new features guide
oracle 9i new features, new features guide, oracle 10g: Hi Shilpi, As indicated in the release notes for Oracle 10g (enclosed in original email), there are no net new database objects introduced with 10g. The list of supported datatypes in 10g is enclosed for your reference: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i45441...

Oracle: Difference between PS records and Oracle tables, oracle tables, oracle table
oracle tables, oracle table, ps records: Hi there, PeopleSoft records are meta-data objects stored within Oracle Tables. The Meta-data objects reference actual Oracle tables. For example: The PeopleSoft record PS_JOB is stored in the table SYSADM.PSRECDEFN (which is a real Oracle table, but...

Oracle: Direct-Load Inserts., load insert, csv file
load insert, csv file, oracle 9i: Hi Mark, From http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2238, under the section Enabling Direct-Path INSERT , it says: Direct-path INSERT supports only the subquery syntax of the INSERT statement, not the...

Oracle: Disadvantage of Index, dss systems, bitmap indexes
dss systems, bitmap indexes, decision support systems: Your question is to wide, but I can answer this way: Bitmap Index vs. B-tree Index: Which and When? by Vivek Sharma Understanding the proper application of each index can have a big impact on performance. Conventional wisdom holds that bitmap indexes...

Oracle: Displaying date
Hello we cannot write :dat:=:sysdate but what we have to write is in the WHEN_NEW_FORM_INSTANCE select sysdate into :dat from dual; or what u can do is go to the propertyy of the item and put default value as $$DBDATE$$ regards...

Oracle: .DMP file, oracle db, oracle 10g
oracle db, oracle 10g, interactive menu: Good morning Mohammed, In Oracle 10g, the EXPORT and IMPORT tools are giving way to a new tool called DataPOump (Export and Import). To create an export file interactively, 1. Set your Oracle DB SID. 2. EXP.exe on Windows or exp on UNIX. 3. Follow...

Oracle: Doubt in query, exact record, fundtrans
exact record, fundtrans, vb program: Hello, Actually I do not remember your query I had replied. But according to what you have stated now, you can run the query as it is through oracle. Check the time it takes. Then create an index on ndate column (which you are using in where clause). Now...

Oracle: Dual table, sql desc, data dictionary
sql desc, data dictionary, sysdate: Hello, Following is the explanation dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql desc dual Name ...

Oracle: Dual, tom kyte, sql desc
tom kyte, sql desc, oracle database: Quoting Tom Kyte dual is just a convienence table. You don t need to use it, you can use anything you want. The advantage to dual is the optimizer understands dual is a special one row, one column table -- when you use it in queries, it uses this knowledge...

Oracle: Duplicate records, duplicate records
duplicate records: hello what is the structure of ur block, which r the field where there can be duplicates. can data repeat in that field i mean can it be a unique field. doing these kind of things in forms is not all that easy. explain me the scenario with an...

Oracle: data transpotation from excel to oracle, oracle home, comma delimited
oracle home, comma delimited, oracle 8i: hello i m sorry i m busy, so i cant send u example. but u can find the examples in the oracle home. as for sqlloader, its a command line utility. u will have to go to the dos prompt and set the oracle sid and then start it some thing like this...

Oracle: data type for dollar amount, integer data types, dual output
integer data types, dual output, datatype: Hi Ryju, To represent any currency(nothing but a float value)in Oracle you have to use the number(p,s) datatype with the declaration of precision and scale i.e sal_in_doller number(9,2) If you want to show the $ sign in the report you can concatenate...

Oracle: database configuration, oracle dba, there is not enough memory
oracle dba, there is not enough memory, select sum: Hi Manish, The DB configurations depend on the behaviour of your database. For starters, since your DB is 24/7, you need to make sure that you can recover quickly. Make sure you have archived log mode enabled. If your application is taking too long to...

Oracle: database design, couple of lines, devx
couple of lines, devx, google: hi subra database design is a concept which cannot be explained in couple of lines or steps. u can search it on google or below r some urls for ur use. http://database.ittoolbox.com/default2.asp http://www.devx.com/ibm/Article/20702 regards ...

Oracle: How to get into the database industry, customer relationship management, ms sql server
customer relationship management, ms sql server, accounting profession: Hi Charles, The easies way would be to take a course on the database (vendor) that you would like to work in. The market currently has several leaders - Oracle (Oracle Database) Microsoft (MS-SQL Server 200x) IBM (DB2) While Microsoft s Access...

Oracle: database links, data dictionary, connection description
data dictionary, connection description, database link: Hi there, The error that you ve encountered is described by Oracle as ORA-02019 connection description for remote database not found Cause: An attempt was made to connect or log in to a remote database using a connection description that could...

Oracle: dba question, cold backups, oracle version
cold backups, oracle version, stratergy: Hello Ramesh the process is a lenghthy one, i need soem more info 1) r u using pfile or spfile 2) is database in archivelog mode or not 3) how big is the database 4) how much dowtime is possible 5) what is ur backup stratergy , i.e. hot or cold backups...

Oracle: dba question, sql tuning, oracle version
sql tuning, oracle version, best regard: Hi Ahmed, Start with Oracle 9i and 10g. These two are the most current release. Start with the Oracle Technology first. Get a strong understanding of how Oracle works overall. Then specialize at tuning SQL. Tuning usually requires a strong SQL understanding...

Oracle: dbca in japanese, windows registry, pb
windows registry, pb, oracle: Hi Philipe, My original answer was provided here http://experts.about.com/q/Oracle-1451/language.htm . Another location that you may wish to check out, is the Windows Registry http://forums.oracle.com/forums/thread.jspa?messageID=1243193 Hope this...

Oracle: dear sir,question no.1:..., oracle database, database answer
oracle database, database answer, default size: Hi, 1. No 2. By using an externally identified user and typing sqlplus / 3. No default size for an Oracle Database, but approx a minimum of 500MB 4. I do not understand the question, but if you mean Oracle Profiles: You can create a profile and grant...

Oracle: decode function in oralce sql/pl, short term memory, search1
short term memory, search1, oralce: Hi Tracy, The DECODE function works its magic the same way as explained in your instructor s note and in the web site that I set. If you can write your SQL to display the data, then you can use the DECODE function to substitute the value for anything...

Oracle: How do we define for PASSWORD, oracle sql, alpha numeric
oracle sql, alpha numeric, password policies: Hi Venkat, If you are planning on storing your password in a table in clear text, that is unencrypted, then whatever your standard is for password would dictate the type. So if your password policy is to use numbers, you can have NUMBERS(X), where X is...

Oracle: deleting rows from Oracle 8i, oracle 8i, uncertainity
oracle 8i, uncertainity, parameter value: hello karel as of 8i u cannot undo the delete once committed, what can be done is only time based recovery to a point where the data existed in the database. or u can use the log miner to extract the data. as of 9i there is a feature called flash...

Oracle: design database, oracle unix, unix platforms
oracle unix, unix platforms, finance departments: Hi Haf, You may be better off at looking for one of the following vendors as they come with the complete suite of what you re looking for: The equivalent product lines from the below companies that you would want is: - HRMS (Human Resources) - Finance...

Oracle: designing a convertor, oracle sql, oracle databases
oracle sql, oracle databases, pl sql: Hi Meera, Unless you are hoping to convert Oracle Triggers (written in PL/SQL) to MS-SQL, you don t need a converter. SQL written using ANSI SQL is compatible in both MS and Oracle. For example, the SELECT statement SELECT * FROM DEPT_TABLE; will...

Oracle: designing a convertor, sql queries, best bye
sql queries, best bye, semantic value: Hai It never minds which s/w u use.But the main thing that is common b/w oracle and mssql or any rdbms is theyre based on SQL .So the query is common for all for example to create table oracle: create table tablename(fieldname datattype...) sqlserver...

Oracle: diff between Orderby and Group by, sort operation, select city
sort operation, select city, varchar2: Hi Gopal, The ORDER BY performs a sort operation. So think of a telephone phone directory. The SELECT NAME FROM DIRECTORY ORDER BY NAME (in this example) would ensure that the result set would be sorted in (by default) ascending order. The GROUP...

Oracle: What is the difference between the following two clause, could you please help?, column name, column names
column name, column names, null value: Hello, We can use nvl ona any side (LHS or RHS), it can be used with column names too. There is no restriction on it. It can be used with a constant value too e.g nvl(100,-1) whose result will be 100 as 100 is not a null value. Hope this answers your...

Oracle: what is the difference between the following two statements, one has two zeros, another has two nines after decimal point?, number 0, point 9
number 0, point 9, decimal point: Hello, I mean to say that 00 or 99 format after the decimal point does not make any difference. But if it is before the decimal point, 9 format is used to replace by blank if format string is more than the number and 0 format is used for substituting 0...

Oracle: How to display a package specification ?, data dictionary, separate objects
data dictionary, separate objects, appdev: Hi Izzzz, The Body and Spec of a package can be viewed by querying DBA_SOURCE (or USER_SOURCE). The Specification (Oracle calls it the SPEC ) is the interface to your applications; it declares the types, variables, constants, exceptions, cursors, and subprograms...

Oracle: How to display a package specification ?, desc, package specification
desc, package specification, package body: Hi, You can display both the spec and body from user_source. For package spec use select line,text from user_source where name = package name and type = PACKAGE order by line; For package body use select line,text from user_source...

Oracle: How to display the value of a BLOB column in SQL*PLUS?, substr, blob
substr, blob, subst: HI there, http://dba.ipbhost.com/lofiversion/index.php/t2817.html provides sample code on how to view content of a BLOB. Enclosed is a summarized cut-n paste from the reference above (note I have included the author s correction in the summary below):...

Oracle: drop down list boxe, drop down list, list box
drop down list, list box: hello manzoor do u have any column in the table for the record that stores the date then u can use it as a reference in the WHEN-VALIDATE-ITEM and check for the record. if u dont have the date column then u need to add a column. Regards Liyaka...

Oracle: Enable cache option for tables, buffer pool, cache option
buffer pool, cache option, oracle 9i: Hi Eve, Enclosed is a link to the Oracle documenation (and example) on how you can pin your database in memory. http://www.jlcomp.demon.co.uk/faq/pin_table.html TO answer your quest, you can just alter the table as shown in the example in the link....

Oracle: Entity Relationship Diagrammer, entity relationship diagram, oracle designer
entity relationship diagram, oracle designer, exact function: Hi An, The ER diagram helps in the following ways, You know what fields are contained in which table You get to know which table can be related to which table to get multitable information. To help you avoid having duplication inforamtion in multiple...

Oracle: Error: 00922 ORA, check default, friends computer
check default, friends computer, misspelt: Hi, The only thing I found wrong in this script was the column course (misspelt as coursr). But if this is a typo mistake, you can try this statement instead Create table Student ( Roll number(4) Primary Key, SName varchar2(25) Not Null, Address...

Oracle: Error while running procedure, sql table, error msg
sql table, error msg, pl sql: Hello, I have not used BULK COLLECT as of now. But while going through a document I found that the variables in which we insert the columns should be of type PL/SQL table. Have you defined the variables in the same way? I cannot point any other error. ...

Oracle: Example System Using Oracle 10gy, enterprise resource planning software, resource planning software
enterprise resource planning software, resource planning software, relational database management: Hi Hally. By Oracle 10g I am assuming the Oracle relational database management system (RDBMS) or database. PeopleSoft (www.peoplesoft.com), Sap (www.sap.com) and Siebel (www.siebel.com) are the top Enterprise Resource Planning software that can use...

Oracle: Explain plan, thanks in advance, indexes
thanks in advance, indexes, oracle: Hi Vikas, An explain plan will show how Oracle will process a given set of SQL statement. Based on the outcome of the explain plan, the developer and/or DBA may choose to for example, re-write the SQL, add/modify/remove indexes, or tune DB parameters, in...

Oracle: Explicit cursor, oracle forms, explicit declaration
oracle forms, explicit declaration, orelly: Hi Subbu, Take a look at Chap 6.3.3. http://www.unix.org.ua/orelly/oracle/prog2/ch06_03.htm Excplicit cursors are one that you declare explicitly. This is the example in that web link: 1 DECLARE 2 /* Explicit declaration of a cursor */...

Oracle: Export Import, metalink oracle, ms dos windows
metalink oracle, ms dos windows, oracle exp: Hi Atul, Before you run the EXP or IMP commands, you have to make sure that the ORACLE_SID variable is assigned to the SID of the database. You can do that within a MS-DOS windows C: ORACLE_SID= SID or DB Name C: (run EXP or IMP). If your database...

Oracle: Export text files to Oracle database, oracle database, export text
oracle database, export text, folder name: Hi Ramesh, Goodday! I think you are not clear in explaining your question. From your question, Daily i m exporting text files to Oracle Database .. I think you are loading external data(text file) to...

Oracle: Export to text files, toad database, database menu
toad database, database menu, sqlplus: Hi, You can also use select query in sqlplus to export data to text file. eg. set pagesize 0 set linesize 500 set heading off set feedback off set underline off set define off spool abc.txt select * from tablename; spool off Apart...

Oracle: Array., sql reference, ordered group
sql reference, ordered group, pl sql: For all practical purposes, one can say that Arrays are what we call Collections in Oracle terminology. a collection, in short, is : an ordered group of elements, all of the same type. It is a general concept that encompasses lists, arrays, and other...

Oracle: Extended/DEFAULT/TO_CHAR., yyyy, dd
yyyy, dd, queries: Hi, 1) When you set a value explicitly to NULL, the default value is not used. But if you do not give any value for the default value column, the default value is used. 2) You cannot use DEFAULT in an update statement. The DEFAULT value is used only...

Oracle: External cursor, pl sql, cursor
pl sql, cursor, cursors: hello when ever we write a query a cursor is created to read the table and fetch the data, this is internal cursor. but when we explicitly write a cursor in a pl/sql block, this is called a user defined cursor. internal cursors are opened, executed...

Oracle: Extracting Time part of date field, hh mm ss, ss hope
hh mm ss, ss hope, hr clock: Hello, If the records are inserted in the format you have said, then I think we will not be able to get the time part. Because as per my knowledge, time part can be extracted only if the records are inserted with the time part. Regards Suchitr...

Oracle: error 12545 connect faild, database version, server thanks
database version, server thanks, os version: hello can u give me some details 1) what is the OS version 2) what is the database version 3) are u getting the error when u r trying to connect from the server or when u r trying to connect from client. 4) do all the clients have the same problem....

Oracle: error : ORA:06502 pl/sql:numeric or value error, sql numeric, pl sql
sql numeric, pl sql, rrrr: Hi, I will not be able to test this procedure as I don t have oracle installed on my m/c. Please can you run this through SQL*Plus and tell me if there are any errors (line no, col no errors). If it is giving error in SQL*Plus, check the lines in table...

Oracle: exact content of a database column, ascii code, exact content
ascii code, exact content, database column: dear yogesh. try this .. SELECT DUMP(desired_column) FROM your_table WHERE some condition ; DUMP(COL1) ------------------------------------- Typ=96 Len=4: 65,66,67,32 For this example the type is 96, indicating...

Oracle: explorer error, internet explorer error, oracle 9
internet explorer error, oracle 9, java exe: Hi, Are you trying to install on a Pentium 4 server? I am asking because I remember there was a bug that caused Oracle not to install on Pentium4 servers/pc s. What option of 9i are you trying to load? Have you tried loading another option (i.e. client...

Oracle: exp_imp problem in oracle, oracle guide, oracle 9
oracle guide, oracle 9, dmp file: Good morning Shivaa, If you have more details about the problem that you are encountering (e.g. error code, etc.), please feel free to send it. I am also enclosing the official Oracle guide on Import and Export for 9.2. http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96652/part1.htm#435787...

Oracle: extracting fmb/fmx files, oracle forms, forms developer
oracle forms, forms developer, remote server: Hi Paul, Putty is not an Oracle delivered product. It is often used to setup a secure connection (i.e. telnet, ftp) to a remote server. So the problem that you seem to be having appears to be a network issue rather than an Oracle issue. You need to be able...

Oracle: Find Children in heirarchy, cos user, cos group
cos user, cos group, group cat: Hi Not sure. But you can try this select a.cat_id from cos_group_cat a start with a.cat_parent_id = (select b.cat_id from cos_user b where b.user_id = &UserID) connect by PRIOR a.cat_parent_id =...

Oracle: Firing DML Triggers during Parent-Child Inserts, oracle db, oracle database
oracle db, oracle database, dml: Hi Esther, Given that you don t know how many child records will be inserted with each parent, you might need to create and run a separate batch process AFTER all the inserts have been completed. This will then enable you to know how many child records...

Oracle: First Step, ms access database, oracle exams
ms access database, oracle exams, first oracle: Hi Syed, There are a number of books and web sites where you can go to get information about Oracle. There are different Oracle Exams (DBA, Developer, Web administrator etc.) Some sites to definitely check out ... www.oracle.com www.orafaq.com www.dbasupport.com...

Oracle: Forgotten password, sqlplus nolog, sid c
sqlplus nolog, sid c, oracle version: hello tell what is ur os and which oracle version u r using. there is no way u can get system password thru scott till the time scott does not have the DBA priv. one thing what u can do is provided u have o/s as windows and 9i release 1 u can do...

Oracle: About Forms 9i, application server, oracle
application server, oracle: Hi The forms can be run without an application server. You may need to pre-compile the code to an executable that can be called by your application. http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830ded916e6b091604851b5e7d70c692eaf22.e34QbhuKaxmMai0MaNeMb3aTaNr0?messageID=426882񨎂...

Oracle: Fresh Graduate, oracle 9ias, application ebusiness
oracle 9ias, application ebusiness, oracle certification: Hi Ankitha, While having passed the certification process will help, there is no substitute for experience. Taking the prepartory courses leading to the exam is by no means a cheap solution. If that s not a problem, then by all means take those courses....

Oracle: Application hangs when user navigates across multiple forms, java trace, java versions
Oracle: Application hangs when user navigates across multiple forms, java trace, java versions, trace level

Oracle: additional columns in a GROUP BY query, aggregate function, select statement
Oracle: additional columns in a GROUP BY query, aggregate function, select statement

Oracle: Create TEMP Table dinamically, external tables, temp table
Oracle: Create TEMP Table dinamically, external tables, temp table, ctas

Oracle: What is correlated subquery?, correlated subquery, logon time
Oracle: What is correlated subquery?, correlated subquery, logon time, excuted

Oracle: create new user, sql commands, oracle
Oracle: create new user, sql commands, oracle

Oracle: Diff between count(1) and count(*), select count
Oracle: Diff between count(1) and count(*), select count

Oracle: Difference between Function and Procedure, resolution example, execution plan
Oracle: Difference between Function and Procedure, resolution example, execution plan, business logic

Oracle: Direct-Load Inserts., load insert, hwm
Oracle: Direct-Load Inserts., load insert, hwm, pitfalls

Oracle: Disadvantage of Index, dss, indexes
Oracle: Disadvantage of Index, dss, indexes, queries

Oracle: Dual, ms sql server, multiple records
Oracle: Dual, ms sql server, multiple records, sysdate

Oracle: Extracting Time part of date field, ssd, milliseconds
Oracle: Extracting Time part of date field, ssd, milliseconds, three characters

Oracle: future of oracle, oracle dba, compition
Oracle: future of oracle, oracle dba, compition, ramesh

Oracle: Host bind array to small, oracle metalink, ivu traffic
Oracle: Host bind array to small, oracle metalink, ivu traffic, traffic technologies

Oracle: Import of dmp(Oracle 9i dump) file, unix directories, unix machine
Oracle: Import of dmp(Oracle 9i dump) file, unix directories, unix machine, windows machine

Oracle: Importing DMP file, cd check, tablespaces
Oracle: Importing DMP file, cd check, tablespaces, dmp

Oracle: Inserting decimal numbers in a Number field, column name, datatype
Oracle: Inserting decimal numbers in a Number field, column name, datatype

Oracle: how i can import database from dmp file, demp
Oracle: how i can import database from dmp file, demp

Oracle: How to import file *.dmp into oracle???, oracle 10g, oracle
Oracle: How to import file *.dmp into oracle???, oracle 10g, oracle, oracle home

Oracle: why important database programming, database program, database programming
Oracle: why important database programming, database program, database programming, programming experience

Oracle: how to insert a date value in oracle insert statement, dd, ss
Oracle: how to insert a date value in oracle insert statement, dd, ss, yyyy

Oracle: Join with possibly empty results, select name, seq
Oracle: Join with possibly empty results, select name, seq, partition

Oracle: How to move database, dmp file, import export
Oracle: How to move database, dmp file, import export

Oracle: Number data type., digit precision, digits
Oracle: Number data type., digit precision, digits

Oracle: ORA-00979: not a GROUP BY EXPRESSION, crop type, target
Oracle: ORA-00979: not a GROUP BY EXPRESSION, crop type, target, neighborhood

Oracle: Oracle 9i installation on windows XP profesional, root admin, good luck
Oracle: Oracle 9i installation on windows XP profesional, root admin, good luck

Oracle: Oracle Trigger Error, loop exception, application error
Oracle: Oracle Trigger Error, loop exception, application error, select count

Oracle: Oracle table creating, best regard, primary key
Oracle: Oracle table creating, best regard, primary key, constraint

Oracle: LEFT OUTER JOIN
Oracle: LEFT OUTER JOIN

Oracle: ora-01536 space quota exceed (Urgent), system privileges, quota
Oracle: ora-01536 space quota exceed (Urgent), system privileges, quota

Oracle: oracle
Oracle: oracle

Oracle: oracle exp utilities, slashes, tokens
Oracle: oracle exp utilities, slashes, tokens, m2

Oracle: oracle v/s foxpro, oracle guide, oracle table
Oracle: oracle v/s foxpro, oracle guide, oracle table, dbf file

Oracle: Prevent "primary-key violation", database side, threads
Oracle: Prevent "primary-key violation", database side, threads

Oracle: how to pivot a string, query result
Oracle: how to pivot a string, query result

Oracle: QUERY TO VIEW THE PROCEDURE, single line
Oracle: QUERY TO VIEW THE PROCEDURE, single line

Oracle: Query on position of column, dynamic sql, stmt
Oracle: Query on position of column, dynamic sql, stmt, statis

Oracle: Question regarding system tablespace, system tablespace
Oracle: Question regarding system tablespace, system tablespace

Oracle: query to fetch all the days between two dates, yy, dd
Oracle: query to fetch all the days between two dates, yy, dd, god

Oracle: Report Server, max connections, application server
Oracle: Report Server, max connections, application server, pid

Oracle: SQL, rownum, ramesh
Oracle: SQL, rownum, ramesh, emp

Oracle: sql, transaction log, oracle
Oracle: sql, transaction log, oracle

Oracle: What is a synonym?, synonym, pointer
Oracle: What is a synonym?, synonym, pointer

Oracle: Thru SQL want to fetch in specifc date format, mm 2
Oracle: Thru SQL want to fetch in specifc date format, mm 2

Oracle: View Procedures, source table
Oracle: View Procedures, source table

Oracle: how to write user-defined functions similar to SUM and MAX, server 101, oracle
Oracle: how to write user-defined functions similar to SUM and MAX, server 101, oracle, docs

Oracle: finding the current financial year in sqlplus, check constraint, check constraints
check constraint, check constraints, sorry for the confusion: Hello, You can try the following CHECK constraint where fdate is from_date, eff_date is effective_date fdate = decode(to_char(eff_date, Q ),1, to_date( 01-APR- ||to_char(to_number(to_char(eff_date, YYYY ))-1), DD-MON-YYYY ), ...

Oracle: Why does the following statement return all record from shipment?, destination toronto, scarborough
destination toronto, scarborough, schema: Hi, does changing the order to something like this make any difference - select client.clientname from client, shipment where client.clientid in (select clientid from shipment where destination = toronto ) and client.clientid = shipment.clientid...

Oracle: a foreign key refer to a combination primary key ?, foreign key, primary key
foreign key, primary key, emp: Hi, Assume table emp and dept. deptno being the primary key on dept. Lets have a foreign key f_deptno in emp. This would mean that with f_deptno we can identify each row in dept. NO lets change the primary key of dept to deptno+dname. To identify each row...

Oracle: forms 6i (d2k),pl/sql, matrix report, sql procedure
matrix report, sql procedure, sql 1: Hello, I had worked on Forms 4.5 2 years back. So I cannot recollect the parameter passing. You can create matrix reports using D2K Reports. The option to be selected is Matrix report. You will find some doumentation/help in the tool itself. Regarding...

Oracle: function, compilation errors, notfound
compilation errors, notfound, datatype: Your error was in datatype of the function parameter, you just don t specify its size... I ve taken the liberty to modify your code below...this is much elegant...as you avoid using RETURN many time...just once on RETURN (p_returned) Advice: Use reserve...

Oracle: functions and package, annual salary, ename
annual salary, ename, input format: Hello Diana CREATE OR REPLACE FUNCTION ANN_COMP (p_sal NUMBER,p_comm NUMBER) Return NUMBER IS v_ann_comp NUMBER; BEGIN v_ann_comp:=(Nvl(p_sal,0)*12)+Nvl(p_comm,0); RETURN v_ann_comp; END; u can use the below query for verification SELECT ename,sal,comm,ann_comp(sal,comm)...

Oracle: future of oracle, oracle dba, better prospects
oracle dba, better prospects, oracle applications: Hi, This course will definitely be good for you. But you have to gain practical knowledge while doing the course or immediately after the course. That will help you in your future for better prospects. Oracle DBA is an area which will always survive....

Oracle: Group by age range, sql query, possible solution
sql query, possible solution, age group: Hi, One possible solution is as below select 0-5 Range, count(user_id) Total_Users from tab1 where age between 0 and 5 union all select 6-10 Range, count(user_id) Total_Users from tab1 where age between 6 and 10 union all select 11-15 Range,...

Oracle: Group by difference between Oracle 8 and 9, oracle 9, oracle 8
oracle 9, oracle 8, oracle: Hi Alex, expression you are using in the SELECT list that was not in the GROUP BY clause. This is the rule while using GROUP BY function (ie: MIN, MAX, SUM, COUNT) ======== Try this: ======== select max(z.a), z.b,(select y from x where aa=z.bb) p from...

Oracle: Groups in oracle, object privileges, oracle users
object privileges, oracle users, sql code: Managing Oracle Roles Administration of large numbers of objects can be difficult. Roles allow you to localize the administration of objects. Roles are most helpful when large numbers of users will need the same system and object privileges (which we discussed...

Oracle: genral questions, oracle database administration, interview questions and answers
oracle database administration, interview questions and answers, questions and answers: HI Sadak, Depending on the company and organization, they may have different needs. You might want to check out dbasupport.com Some questions that you may be asked on - day-to-day database administration (table/tablespace resizing); - Backup and...

Oracle: getting a good advisment, internet job postings, ms sql server
internet job postings, ms sql server, open source project: Hi Mohammed, Take a look at the job market in your area (i.e. via internet job postings, newspaper advertisements etc.) to gage the demand for such skills. There are fewer developers than there are DBAs. But there are DBAs who are specialist in their field....

Oracle: guide, oracle sql, oracle dba
oracle sql, oracle dba, pl sql: Hi, I would suggest you do some oracle basic courses. You also try to get a job in Oracle. B coz experience in Oracle is required for all DBA activities. So first develop your skills in oracle - sql, pl/sql, etc and side by side gain knowledge in oracle...

Oracle: Help for Oracle 9I SQL, dual group, sysdate
dual group, sysdate, oracle 9i: These two examples illustrate a option to solve your problem: Using group by cube Example 1: ___________________________________________________ select a, c, sum(b) from ( select sysdate a, a c, 10000 b from dual union all select sysdate, a...

Oracle: Help for Oracle 9i SQL, expression error, bhupendra
expression error, bhupendra, oracle 9i: hi abathun, NOT A GROUP BY EXPRESSION error messagecomes only when then group function is not used properly.In our case it is sum() function. Unfortunately I do not have oracle server to test this code that s why I have given you 2 different syntax...

Oracle: Help for Oracle 9i SQL, oracle 9i, lcy
oracle 9i, lcy, credit transactions: Hi, The code would look something like this: break on value_dt skip 2 compute sum of DEBIT CREDIT on value_dt select ac_no, value_dt, decode(DRCR_IND, D ,-1*LCY_Amount, ) DEBIT , decode(DRCR_IND, C ,LCY_Amount, ) CREDIT from acvw_all_ac_entries...

Oracle: Help for SQL, lcy, credit transactions
lcy, credit transactions, debit and credit: Hi, According to my knowledge, sql query will not work for this type of output. You will have to use reports for this. If you use sql query you will get balance on each row. Other solution is to create a view for the date, account and balance column and...

Oracle: Help-Urgent please, oracle 10g, oracle 9i
oracle 10g, oracle 9i, using oracle: Hi Kaylan, Have you ever had Oracle 9i installed before Oracle 10g? Do you have Oracle 9i installed as well as 10g? One possible problem is your definition of your database in the TNSNAMES.ORA file is incorrect (either PORT # is wrong, or the database...

Oracle: Help, problem mail, c oracle
problem mail, c oracle, code vb: Try to use this type of connection. Dim OraSession As OraSessionClass Dim OraDatabase As OraDataBase Dim DynTabela as OraDynaset Public Enum EnuAbertura EnuORADYN_DEFAULT = &H0& Accept the default behavior. EnuORADYN_NO_AUTOBIND...

Oracle: Hiding Default Menu Of Forms 6i, default menu, forms6i
default menu, forms6i, menu module: hello aparna make sure what is the path of the form and if the duplicate form exists somewhere. so check whether u r copying the right file to the right location and u dont have any duplicate forms. or if u want u can restart the formserver. thanks...

Oracle: Host bind array to small, sun solaris 10, varchar2
sun solaris 10, varchar2, proxy classes: Hi there.... I haven´t understand your function, I guess you didn´t send me all of it. Please send me all the code. But I have compiled the type and the procedure (commenting the part of the function) and it ran successfully. So I guess the problem...

Oracle: Hot & Cold Oracle Database backup - script, backup host, oracle 9i
backup host, oracle 9i, backup script: Hi, For a cold backup all you need to do is shutdown your database (NOT shutdown abort), and copy all the relevant files to your backup device. You can get all the files to be backed up by doing: select name from v$datafile; select member from v$logfile;...

Oracle: HWM, asktom oracle, high water mark
asktom oracle, high water mark, hwm: Hi Deepak, http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:669044239081 AskTom s websit has a great forum on the discussion and details of the HWM. IN general, when a table is create its HWM is at its minimum. As the table grows (i.e....

Oracle: handing db_link error in exception, oracle error, oracle support
oracle error, oracle support, link error: Hi ravi, 1) Oracle execptions are: Oracle Exception Name Oracle Error Explanation DUP_VAL_ON_INDEX ORA-00001 You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index....

Oracle: help on management server name, oracle management server, education purpose
oracle management server, education purpose, oracle 9i: hello oliver host name means the name of ur machine, u can find host name by right click on the my computer and see the properties , then click on the network identification tab , this will show the machine name as for locating the management server,...

Oracle: one help pls., web logic server, internet application server
web logic server, internet application server, web application server: There wont be Any Application Server Developer , There would be administrators who would help you to administer the Web Application Server. You need to find Web Application Administrator for that specific product. For example Oracle uses iAS ( Internet Application...

Oracle: help, developer oracle forms, oracle forms 6i
developer oracle forms, oracle forms 6i, database management systems: Hi Mark, Oracle is a software company famous for its Releational Database Management Systems (RDBMS). Founded in 1973, Oracle is a leader in RDBMS development. In the last 5 years, Oracle has also developed eBusiness Suites of software (e.g. Financials,...

Oracle: IT @ home, formal discovery, priviledge
formal discovery, priviledge, time business: Hi Michael, Many employers do allow employees to telework on a part time bases (max 3 times a week for example). Having said that, it depends on the work involced. You have to remember that a lot of work is performed as a team and will require face-to-face...

Oracle: How to Import .dmp file into Oracle8i, step guidance, doc server
step guidance, doc server, import command: Hi Jay, You ll still run into the problem with the existing data that are in the tables. You can remove the data from those tables by issuing the TRUNCATE TABLE command (note: it s really fast, but you cannot rollback, it s permanent). Using DELETE FROM...

Oracle: Import dmp file, active interface, oracle data
active interface, oracle data, oracle database: Hi Moinuddin, This is not too bad of an issue. Essentially a synonym exist so that other users can reference your tables without necessarily having to include the SCHEMA prefix e.g. TAL.CODE_DESCRIPTION can be referenced in SQL by CODE_DESCRIPTION....

Oracle: Import of dmp(Oracle 9i dump) file, dmp file, low disk space
dmp file, low disk space, ping test: Hi Ramya, There isn t any way to have your database server recognize the server where your dump file is located, as a mount point or drive mapping. On a Windows to Windows platform, you could try to setup a share between the two servers and treat the...

Oracle: Import /Export Problem, target database, oracle account
target database, oracle account, password answer: Hi Vikas, Assuming that you can already log in to the target database, and assuming that you have the granted privilege, CREATE SCHEMA: CREATE user IDENTIFIED BY password Storage clauses Storage clauses refers to which tablespace this schema...

Oracle: Import in order to tables, oracle import, using oracle
oracle import, using oracle, data buffer: Hi Amitabh, You can create a PAR file (http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1021478). In the PAR file, you can specify the table order as a parameter. It would look something like this (example follows): The...

Oracle: Import in order to tables, oracle import, import utility
oracle import, import utility, using oracle: Hi Amitabh, Using Oracle IMPORT, you can get some generic HELP information by typing IMPORT.EXE -HELP (for windows) or imp -help (on unix). Additional Reference: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm (Chapter 19 on...

Oracle: Importing Data into Oracle, windows 2000 advanced server, oracle 9i
windows 2000 advanced server, oracle 9i, woring: Hi Murthy, What is the IMP command (along with the flags) that ou used to import the data? The other possibility is that your friend only exported user and not any other data. You may want to get your friend to double-check his data and re-try. Pete...

Oracle: Importing DMP file, target database, database 2
target database, database 2, database user: Hi Vinob, You may want to copy the files from your CD to your local disk. This allows you have have easier access to the data. Enclosed is the link to the reference manual that ll help you with the step-by-step. http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm...

Oracle: Importing a database, dba oracle, oracle tips
dba oracle, oracle tips, trace directory: Hi Rohit; The answer to your question comes courtesy of Mr. Don Burleson (http://www.dba-oracle.com/oracle_tips_db_copy.htm): --- Forwarded information --- This procedure can be use to quickly migrate a system from one UNIX server to another. It...

Oracle: Importing in ORacle, oracle 8i, dmp file
oracle 8i, dmp file, using oracle: Hi Hitesh, When you run the IMPORT command in interactive mode ((by answering the prompted questions), you can specify the tables that you wish to download. The enclosed is the associated HELP file should you wish to try to use the SILENT mode: You...

Oracle: Improving database/webserver efficiency, university web server, open source java
university web server, open source java, garbage collections: Hi John, I am not the next door Java kind of a guy so wouldn t be able to help you much in this regard. However, if you can use ASP.NET for the web application part, I can bet you ll get a superb performance. It has all the features you require or have...

Oracle: Improving database/webserver efficiency, source web server, university web server
source web server, university web server, bea tuxedo: Hi John, Typically there is an application server between the web server and the database server. There are a number of app server on the market, BEA Tuxedo, IBM Websphere and I believe there are some J2EE open source web servers (JBOSS www.jboss.org)....

Oracle: Improving database/webserver efficiency, query response time, university web server
query response time, university web server, open source java: Hi John, I am not really a programmer, but I ll give you my thoughts from a database point of view. To start, have you had a look at the query response time by using something like sqlplus? Also, looking at the explain plans of the queries might be a...

Oracle: Including dynamic graphics into reports, tabular report, oracle reports
tabular report, oracle reports, select city: Hi Karel, I guess one way to go about this issue is to create a blank image file named noimage.jpg. Place it in the same folder as the other image files. now modify your query as select city_name, c:pictures ||NVL(city_name, noimage )|| .jpg ...

Oracle: Incremental Backups, incremental backups, incremental backup
incremental backups, incremental backup, differential: Dear Mark, Baseline backup or level 0 backup one and the same. level 0 backup is nothing but taking backup of whole database. differential/incremental backup: Taking the backup of only modified since the last backup. cumulative backup: Taking the backup...

Oracle: Indexes., asktom oracle, oracle indexing
asktom oracle, oracle indexing, b tree: Hi Mark, Here s some great sites that will further explain how Oracle Indexing works: http://www.evdbt.com/2004_presentation_549.ppt http://www.dbazine.com/oracle/or-articles/burleson25 http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2913600659112...

Oracle: Indexes, asktom oracle, b tree
asktom oracle, b tree, jagadeesh: Hi Jagadeesh, Of all the indexes, the most commonly used is the B*-Tree index. It s a B-Tree (http://fast-track.cc/phys_123.htm). There s also a BITMAP Tree index (http://www.akadia.com/services/ora_bitmapped_index.html). I highly recommend using Explain...

Oracle: Insert Rights in a table, sql commands, system tables
sql commands, system tables, previous question: Hi Natraj, If a user is granted SELECT, INSERT, UPDATE, DELETE on table A, for example, they can issue SQL commands to insert, update or delete data. To be able to execute a stored procedure written and owned by another schema, then you will need to also...

Oracle: Insert rows in a table, 36 dd, sql desc
36 dd, sql desc, gg: Hi Kevin, You will have to add the rows for all countries with year 2006 and salary as null. Use the following query - insert into k1 (select country, 2006 ,null from k1 where year = 2005 ); This is assuming there exists rows with year 2005...

Oracle: Inserting decimal numbers in a Number field, bijay, precision scale
bijay, precision scale, decimal numbers: Hi Bijay, When you have a column with NUMBER datatype, it should take 1.123 as a valid value and should display the same through the select statement. I see no reason why you should get 1 instead of 1.123. Are you having any variable (with diff datatype)...

Oracle: Installation Problem, host string, installation tasks
host string, installation tasks, oracle 10g: Hi Zizou, Try to run the install again. Oracle might be able to detect that you re installed and might bring you back to the post installation tasks again. If it doesn t, just uninstall and re-install it again. Use this guide to help with the installation...

Oracle: Installing Oracle 8i on a PC that has Windows ME., installing oracle 8i, lake oswego
installing oracle 8i, lake oswego, alpesh: Hi there, The Oracle install documentation is available from Oracle at technet.oracle.com. You might want to check to see if Oracle supports WinMe (I am not sure but I don t think it is supported -- W2K and WinXp is supported). Hope this helps. Pete...

Oracle: Installing Oracle Client in XP, oracle client, oracle enterprise
oracle client, oracle enterprise, reply thanks: Hi Kapil, http://download-east.oracle.com/docs/cd/B19306_01/install.102/b14314/toc.htm provides the official Oracle steps for installing your Oracle Client on your PC. The only configuration would be your TNSNAMES.ORA file to add the Oracle database(s)...

Oracle: IP address change on unix server, oracle 8i, port of fujairah
oracle 8i, port of fujairah, microsoft odbc: Hi Manesh, 1. In your database server, anywhere where you ve hardcoded an IP address will be affected. Thus your TNSNAMES.ORA file, and your LISTENER.ORA files come to mind. If you are using a fully qualified domain name, e.g. server.company.com, then...

Oracle: Italy, oracle forum, history of italy
oracle forum, history of italy, roman times: Hi Mathieu, I think you have the wrong category (This is an Oracle forum). Might I direct you to http://en.wikipedia.org/wiki/History_of_Italy_during_Roman_times and http://en.wikipedia.org/wiki/History_of_italy as one of many sources of information...

Oracle: imp oracle8i server procedure, ms dos command, oracle8i server
ms dos command, oracle8i server, import command: Good day In order for you to perform the importdo it using command line, in this case, MS-DOS command. The import command is IMP which is located in your Oracle bin directory. The command to perform the import is as follows: C: IMP username...

Oracle: import data from externam data files using SQL LOADER, shiju, dml statements
shiju, dml statements, character fields: Hi, According to my knowledge, if this table is an external table, you will not be able to issue any DML statements as external tables are read-only. You can create ta temp table and try giving this sqlldr command. If it works, then the above case is...

Oracle: how i can import database from dmp file, step manner, anupam
step manner, anupam, oracle: Hi Anupam, http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1023560 will provide the complete information that you might be looking for. If you use the interactive process, you will be prompted for what to backup and import....

Oracle: How import *.dmp file in my Oracle 9i?, target database, database source
target database, database source, source database: Hi Sheetal, The error ORA-00992 : invalid format for REVOKE command, indicates that a REVOKE command was improperly invoked. Either there is a problem in the source database or in your target database. I would suggest that you try to re-export and check...

Oracle: How to import file *.dmp into oracle???, file dmp, ms dos command
file dmp, ms dos command, dos command line: Hi there, To import a dump (.DMP) file into Oracle, you need to do this from your MS-DOS command line and not using SQL*Plus or the SQL*Plus Worksheet. If you were to type the IMP -? from the command line, you will see the command syntax that you were...

Oracle: why important database programming, db structure, proprietary features
db structure, proprietary features, support sql: Hi André, Database (DB) programming follows SQL-92 standards as defined by the ISO (International Standards Organization). All major database vendors database product support SQL-92. However they each embed their own proprietary features that make...

Oracle: importing data into new user, oracle 8, windows 2000 server
oracle 8, windows 2000 server, dmp: Hi, What error are you getting when the import fails? Are there any messages in the alert.log file? Make sure the user to are importing to have a default tablespace set other than SYSTEM, and make sure that the tablespace have enough space available...

Oracle: importing xcel data to oracle table, csv file, oracle table
csv file, oracle table, ascii mode: Hi Anu, Possible cause 1: You are loading the data (CSV file) on a unix server. If this is the case, then there may have been a problem with your file transfer from a Windows to unix server. Try to re-ftp the file but make sure to transfer using ASCII mode...

Oracle: imprt and export of database, delimited format, csv file
delimited format, csv file, oracle data: Hi Anand, There are two ways. 1. The easist method is to convert your MS Access data into .CSV (delimited format or fixed length format). Make sure the .CSV file layout follows the layout of the Oracle data table in question. You can use SQLLOADER...

Oracle: inner/outer join, customer table, column id
customer table, column id, b product: Hi Izzzz, Sorry was sick the last few days. To answer your first question, it can be restated as follows: 1. Join the result set with the PRODUCT table to pull up the list of items matching that customer s product. 2. Generall. Although it can vary...

Oracle: how to insert a date value in oracle insert statement, ss hope, database level
ss hope, database level, database table: Hi, Please try following query INSERT INTO X VALUES (99,TO_DATE( 1998/05/31 12:00:00 , YYYY/MM/DD HH24:MI:SS )); The date format in which the date is stored may be different for a database. So we have to explicitly mention the format of the date/time...

Oracle: inserting into a column, sid number, stock values
sid number, stock values, insert into values: hello just copy and paste this insert statement i have just tried it and it worked fine for me. INSERT INTO STOCK VALUES(1001,LEDGER_DEBIT_TYP(2050,null,null,null,null,null,null,null,null,null,null)); in case u get error give me the exact error...

Oracle: inserting data into oracle through shell scripting, oracle database table, unix scripting tutorial
oracle database table, unix scripting tutorial, shell scripting: Hi Sanjay, Here s a sample shell script sqlplus -s usr/pwd EOF audit.log select * from emp; exit EOF Where usr/pwd is the Oracle username and password respectively. audit.log is the output file. You can also assign variables within your unix...

Oracle: install oracle 9i, java wizard, oracle 9i
java wizard, oracle 9i, windows home edition: Hi Talal, There is a setup.exe file. All you have to do is run setup.exe and follow the java wizard to install the Oracle 9i. You have to make sure you re using the standard addition. If you re not sure, you can check at technet.oracle.com. Pete...

Oracle: How to install/use Export Utility (ver 9.0.1.0.0) in Oracle Enterprise Manager Version 9.2.0.1.0 to export data, oracle enterprise manager, dmp file
oracle enterprise manager, dmp file, c oracle: Hi Cindy, You should use the old tools to EXPORT (so use 9.0.1.0.0) and use the new tools to IMPORT (so use 9.2.0.1.0) the .DMP file for the upgrade. You should not be using the catexp7.sql from 9.0.1.0.0 for 9.2.0.1.0. The latest version of Oracle 9i...

Oracle: How to install/use Export Utility (ver 9.0.1.0.0) in Oracle Enterprise Manager Version 9.2.0.1.0 to export data, oracle enterprise manager, oracle error
oracle enterprise manager, oracle error, oracle home: Hi, Is it not possible for you to connect to stateA from the stateB server, i.e. exp scott/tiger@stateA.world , by adding stateA in your tnsnames.ora file on your stateB server? Then you do not have to install new software on stateA. If not, then I...

Oracle: installation, oracle 7i, otn oracle
oracle 7i, otn oracle, sco unix: Hi Shinil, I m not sure what that error is. However, I would recommend that you upgrade to at least Oracle 10g (Oracle 9i s desupport was announced by Oracle recently). You can download an evaluation copy at otn.oracle.com, click on DOWNLOAD from the menu...

Oracle: I installed Oracle xe on my..., environmental variables, database instance
environmental variables, database instance, select properties: Hi Hong, Causes of ORA-27101 Unable to locate shared memory realm. So it may be one of this 1. You may have modified your Database Parmaters (SGA Size or some other related parameter). Action: Restore original parameters that you may have changed...

Oracle: about interview, oracle database software, post graduate diploma
oracle database software, post graduate diploma, storage estimation: Good day sir, To become an Oracle DBA, you need to understand the functionalities and capabilities of Oracle 9i and/or 10g RDBMS. These are the two most current and widely used Oracle Database software world wide. There are only a smaller subset of Oracle...

Oracle: How can I get the iSQL*Plus environment in Oracle 9i, oracle 9i, isql
oracle 9i, isql, apache webserver: hello rajib if u have done the typical installation of oracle 9i u can use the following 1) start the listener 2) start the database 3) start apache webserver 4) in the internet explorer type http://localhost/isqlplus thanks Liyakat ...

Oracle: Join with possibly empty results, migration issue, union clause
migration issue, union clause, oracle server: Hi there... What you want is to get a parent-child model and transform it in a generation model. It´s used done (and I also recommend it) by creating another table and fill it by the hierarchy came from the origin table. I suggest to create a procedure...

Oracle: Link Table 00604 Error, oracle support services, oracle 9i database
oracle support services, oracle 9i database, internal dictionary: Hi Jean, According to Oracle: ORA-00604 error occurred at recursive SQL level string Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). Action: If the situation described...

Oracle: No Listener, oracle tnsping, listener services
oracle tnsping, listener services, c oracle: Hi Luis, Have you started up the LISTENER services? There are two quick checks: 1. At a DOS/CMD line prompt, type c: tnsping.exe [database_sid] where [database_sid] is the database you are trying to connect to. It should return something like...

Oracle: Locked Table, session s2, session s1
session s2, session s1, oracle 8: There is a very comprehensive explaination in http://orafaq.com/node/854 - The statement you re looking for is: SELECT s1.username|| @ || s1.machine|| ( SID= || s1.SID|| ) is blocking || s2.username|| @ || s2.machine|| ( SID=...

Oracle: Logging trigger, oracle 8i, thanks in advance
oracle 8i, thanks in advance, oracle: Hi Gireesh, I am assuming that you wish to audit actions transpire within SQL*PLUS for a given user (e.g. DBA). http://www.oracle-base.com/articles/8i/Auditing.php (note this is for Oracle 8i). http://www.securityfocus.com/infocus/1689 (note for...

Oracle: Logical Directories/External Tables., directory object, sql package
directory object, sql package, physical directory: Oracle introduced the concepts of DIRECTORY objects in Oracle 8.0. DIRECTORY object is a logical structure that represents a physical directory on the server s file system. Initially the DIRECTORY object was used only in context of the DBMS_LOB PL/SQL package,...

Oracle: Login Button, check username, simple logic
check username, simple logic, insurance type: lets assume we have a drop list by the name of :ins_type and the tables as user_tab with user_name,pwd,ins_type as columns :user and :pass as forms columns in this case if we have only one table we can have a simple logic. declare v_user varchar2(30);...

Oracle: Login Problem, exact error message, oracle 10g
exact error message, oracle 10g, tnsnames: Hi Rahul, There are a number of checks that you need to do when you get this type of error: 1. Is the database started and running? 2. Is your listener started and running? 3. For Oracle 10g and XE, you need to check to make sure that the OEM console...

Oracle: Looping through a Ref cursor, loop through, cur
loop through, cur, package body: Hi there... The problem seems to be in this line: TYPE MY_CUR IS REF CURSOR; If you change for MY_CUR Varchar2(100), for example, works! I haven´t really understand what this line is mean to do... I mean, I know that you want to declare a cursor...

Oracle: Lost pasword!, system passwords, dba group
system passwords, dba group, orapwd: You don t mention the OS. If it is unix, you can login as internal (DBA group user doesn t need to supply the password for that) and change the SYS/SYSTEM passwords. If it is NT you can delete the password files and create the new one using oradim/orapwd...

Oracle: language, japanese langauge, japanese lanaguage
japanese langauge, japanese lanaguage, critical servers: Hi Ankit, You will probably need to change the Windows OS default language to English for the DBCA application display the English messages. I would not recommend doing this on any of your mission critical servers without first testing and doing during...

Oracle: login problem in oracle management server 9i, oracle management server, oracle listener
oracle management server, oracle listener, oracle 9i client: Hi There, You might want to make sure that your TNSNAMES.ORA is configured to connect your database. Another check you want to look at is to make sure that your Oracle Listener is up and runnng. On Unix, you can use the ps -ef |grep lis. On Windows, click...

Oracle: Managing Rollback Segment Manually, rollback segment, rollback segments
rollback segment, rollback segments, oracle 8i: HI Ashok, If you have lots of rows to delete from a table, using the DELETE DDL is not a great idea. DELETE, like INSERT, uses rollback segments to cache the data until a COMMIT is issued. If you don t have a large enough rollback segment, you ll get the...

Oracle: Materialized View, oracle 10g, server 101
oracle 10g, server 101, oracle database: Hi Shkeel, Reference: http://www.databasejournal.com/features/oracle/article.php/2192071 The materialized views are snapshots of data from your master table, but stored on a remote local machine. To be able to update the local copy and then have the...

Oracle: Matrix, matrix report, inner frames
matrix report, inner frames, mail: hello hari u make a copy of the report first and then, increase the outer most frame a little or try to adjust the inner frames & repeating groups with a steady hand and adjust it as per ur needs. if not successful mail me the report at liyakat_x@indiatimes.com....

Oracle: MIS&ORACLE, oracle 9ias, oracle designer
oracle 9ias, oracle designer, oracle 11i: Hi there, There are a variety of Oracle 9i application available, such as + Oracle 9i RDBMS (Enterprise Server) + Oracle 9iAS (Application Server) + Oracle Designer + Oracle 11i eBusiness Suite + Oracle 9i RAC (Real Application Cluster) The latest...

Oracle: Migrating Oracle DB for peoplesoft, oracle db, logical pieces
oracle db, logical pieces, dbfs: Hi Chandra, When using the EXPORT - IMPORT method, you re not moving the physical DBFs that make up the database. Rather, you are moving the logical pieces, the data, tables, etc. The premise is that you ve created your 10g instance and preconfigured...

Oracle: Migration, orcl oracle, oracle system
orcl oracle, oracle system, oracle home: Hi Subangini, The Oracle System Identifier (SID) is the name of the given database instance. If you look at your Oracle s TNSNAMES.ORA, you should be able to identify the SID by looking for the SID= entry. Alternatively, you may see a service name. Use...

Oracle: Migration, oracle migration, migration toolkit
oracle migration, migration toolkit, csv file: Hi Subangini, There are commercial tools available that you can purchase that can accomplish the migration. An example: http://www.mysql.com/products/tools/migration-toolkit/tutorials/OracleMigrationTutorial.html http://www.mysql.com/news-and-events/on-demand-webinars/oracle-migration-2006-06-13.php...

Oracle: Move Oracle database, oracle 7, oracle 9
oracle 7, oracle 9, oracle 9i: Hi Stein, Assuming that you ve installed and configured your Oralce 9i or 10g software, create an empty database instance. To move the database, simply perform an EXPORT using Oracle 7.3 and then use the Oracle 9i or 10g IMPORT to load the .DMP file into...

Oracle: Multiple listener for multiple db's, default port number, oracle service
default port number, oracle service, dynamic discovery: Hi Gabriel, This case from Oracle shows you how to configure the listener using the non-default settings: Doc ID /help/usaeng/Search/search.html : Note:91174.1 Content Type: TEXT/PLAIN Subject: How to Configure Listener Using Non-Default Setting...

Oracle: Mutating table., check constraint, sql programming
check constraint, sql programming, database trigger: Hi, Table constraints are restrictions on the table/fields. Some egs are unique constraint (unique value in a field), check constraint (check for specific value in a field), foreign key constraint (add references from different table) Mutating table...

Oracle: i m very confuse, oracle dba, oracle education
oracle dba, oracle education, developer 2000: Hi Awanish, Developer 2000 (D2K) is being slowly phased out. If you plan on pursuing a career in the development field, you can take a look at Oracle Fusion as well as its JDeveloper stream. If you are interested in the field as a database administrator...

Oracle: major performance tuning parameters in oracle 9i, solaris operating system, pctfree
solaris operating system, pctfree, unix environments: Hi Shekar, PCTFREE and PCTUSED are calculated using the following formulas: PCTFREE=(average row size -initial row size)*100/average row size PCTUSED=average row size*100/available data space Now i cannot say whether pctfree with value 2 and pctused...

Oracle: how to minimize the query execution time, oracle optimizer, oracle 8i
oracle optimizer, oracle 8i, dba tools: Hi Shahnawaz, While the query is running next time, using your DBA tools, capture the SQL and run an EXPLAIN PLAN to determine how the Oracle optimizer is fetching the data. I am assuming that the LOV you refer to is the LIST OF VALUES generated from an...

Oracle: How to move database, oracle enterprise manager, command line parameters
oracle enterprise manager, command line parameters, schema manager: How does one use the import/export utilities? Look for the imp and exp executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters before starting....

Oracle: multi-table validation (pl/sql), table validation, pl sql
table validation, pl sql, sql script: Hi Joshua, You need to identify which of the three tables would serve as your master record. Essentially if you find data in your master but not in the other two tables, then you would delete those records. Once you ve chosen your master table, your...

Oracle: Network, oracle enterprise manager, network utilisation
oracle enterprise manager, network utilisation, network question: Hi Shinil, Here are some checks that should be performed against the database. 1. What is the current various dictionary ratios? Use http://vsbabu.org/oracle/sect05.html for scripts. Note the % provided are suggestions/guidelines. You will have to...

Oracle: Number data type query, place hope, space issue
place hope, space issue, type query: Good day, In Oracle perspective, 20.00 or 20, both of them represent the same number, i.e. 20. It is not possible, my best knowledge, to force Oracle to store the decimal in a number(p,s) data type column in this situation. The other question is why...

Oracle: Number data type., decimal place, whole number
decimal place, whole number, digits: Hi Mark, when you declare a variable as number(m,n), it signifies the number comprises of m digits(0-9) out of which 2 are reserved for the decimal(after the .) and hence 3 for the whole number part. So number(5,2) denotes that you can store a number...

Oracle: need for a solution, oracle 8i, uk oracle
oracle 8i, uk oracle, oracle 9i: Hi anirban, You will find everything related to pl/sql at the following sites - Oracle 8i - http://oracle.cs.uoi.gr/enterprise_server/server.815/a67842/toc.htm Oracle 9i - http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/toc.htm...

Oracle: normalizing tables, b tree, jane smith
b tree, jane smith, desired outcome: Hi David, It depends on the what exactly the query and desired outcome is. Indices are used to speed up search of frequently used data. It make no sense to index all 100 columns to find an intersecting row (Your experience is correct). Indices uses...

Oracle: Object Type Query, type sql, type query
type sql, type query, sql queries: HI Philip, I m not sure what you mean by OBJECT TYPE SQL query. You can create a wide variety of SQL queries on the personal details that you indicated. For example, If I wanted to list and count everyone s distinct last name, the query that I could...

Oracle: About OCA, entry level job, microsoft certification
entry level job, microsoft certification, mca: Hi Girish, after completing OCA, it would certainly be difficult to get entry level jobs too, as even people hesitate in recruting fresh OCP s as DBA jobs require quite a lot of experience. So it s better if you go if for OCP by appearing for the remaining...

Oracle: About OCP-DBA certification, retailer amazon, pls web
retailer amazon, pls web, oracle press: Hi Saurabh, I just did a query on the online book retailer AMAZON.COM and here s a list of books available: http://amazon.com/s/ref=nb_ss_gw/105-1491138-0159607?initialSearch=1&url=search-alias%3Daps&field-keywords=oracle+ocp&Go.x=0&Go.y=0&Go=Go Personally,...

Oracle: OFA DISADVANTAGES, oracle database, configuration problems
oracle database, configuration problems, installation configuration: Hi Luis, By installing Oracle following the OFA, you are following a standard. Any new DBA coming to work in our organization will be able to locate files and information easily. The only difference would be the SID name, which will vary by organization....

Oracle: OFA, production instances, oracle 9i
production instances, oracle 9i, maintenance reasons: Hi Chris, Pre Oracle 7.3x, there was not real set in stone procedure for installing Oracle. This led different approach on where the files should be held. When the OFA was first published by Millsap (1995), it defines a standard. So if anyone new to your...

Oracle: ORA-00001 Unique constraint violated. (Invalid data has been rejected), duplicate keys, unique key
duplicate keys, unique key, primary key: Hi, Cause This error means that an attempt has been made to insert a record with a duplicate (unique) key. This error will also be generated if an existing record is updated to generate a duplicate (unique) key. Typically this is a duplicate primary...

Oracle: ORA-00955, drop index, ahad
drop index, ahad, existance: Hi Ahad, Check the name of the object in existance against the system table DBA_OBJECTS (or USER_OBJECTS if you don t have access to DBA_OBJECTS). Who owns that object. If someone else owns it, you can ask if that person needs it or not. If they do, you...

Oracle: ORA-00979: not a GROUP BY EXPRESSION, crop type, target
crop type, target, ultimate solution: SELECT POTENTIAL_CALC_MASTER.POTENTIAL_CALC_MASTER_ID, MAX(POTENTIAL_CALC_MASTER.TARGET_YEAR), FRMR_CROP_DET.CROP_TYPE, count(FRMR_CROP_DET.CROP_TYPE) FROM FRMR_CROP_DET INNER JOIN POTENTIAL_CALC_MASTER ON FRMR_CROP_DET.CROP_TYPE = POTENTIAL_CALC_MASTER.TARGET_CROP_TYPE...

Oracle: ORA-00979: not a GROUP BY expression, exact details, rte
exact details, rte, pult: Hi Sudhir, Sorry for the delay. The problem in above sql is that we need the same columns in the group by clause as that in the select clause. So you may try this query - SELECT OPWD.DLVRY_RTE_MAST_ID,ODRM.RTE_CD,OW.WAYBL_NO,GET_BR_NM(OW.BKG_BR_MAST_ID)...

Oracle: ORA-00979: not a GROUP BY expression, currency name, code group
currency name, code group, hdr: I really didn´t understand what you want...but here goes an advice: Which columns must be in the group by clause: All columns that are being selected and are not group functions: Group functions: Sum(), max(), min(), avg()... Example Select...

Oracle: ORA-01033, shutdown command, open test
shutdown command, open test, client error: Tom, When you shutdown your database, did you use just SHUTDOWN or SHUTDOWN IMMEDIATE? The latter usually removes any connections to the databases. THe alert.log is the general goto place for errors. Another thing to check for is if there is any problems...

Oracle: ORA 01033 Error, oracle error, oracle 9
oracle error, oracle 9, back ups: Hi Sat, I do no understand what you mean by The Database is Password Protected by the Vendor and can not be logged in without using the GUI, hence we are unable to close/ shutdown the database/ or reopen it. You might have an ordinary user Oracle account...

Oracle: ORA-01033 Error, oracle 8i database, google search
oracle 8i database, google search, c oracle: Hi Mike, Try the following steps in sequence. If you get an error, please let me know. 1. Shutdown database (as indicated before). 2. Connect Internal. 3. run STARTUP MOUNT; This steps mounts the database but it is still not open; 4. If 3 works, run...

Oracle: ORA-01034,ORA-27101, oracle rdbms, rdbms software
oracle rdbms, rdbms software, tns could not resolve service name: Hi Suketu, $ORACLE_HOME is where you installed the Oracle software. For exmaple, if I had installed Oracle in C:ORACLE817... then that is my $ORACLE_HOME. So if I wanted to access the programs in the BIN folder, I could do something like cd $ORACLE_HOMEin...

Oracle: ORA-01536 problem (Urgent), expert friend, jagan
expert friend, jagan, mb space: Hi Jagan, Here s some tips from Oracle about how to solve this problem: Errors ORA 1536 space quota exceeded for tablespace name Symptoms Insert on a table reports,ORA-01536. But enough space is available in the tablespace. grant unlimited...

Oracle: ORA-27101, dba oracle, oracle 10g
dba oracle, oracle 10g, listner: Hi Vico, The steps to creating a database from the command line (assuming Oracle 10g) can be found here: http://www.dba-oracle.com/oracle_create_database.htm or http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html AS for your ORA-27101 error,...

Oracle: ORACLE/D2K, d2k, model project
d2k, model project, saravanan: Hai I am not clear with ur Question.Where ur going to Run ur form either from d2k itself or from system folder. One possibility is You can create a shortcut for fmx in its property.Then u can set ur path with username password in shorcut keys....

Oracle: ORACLE DB Backup, oracle db, oracle database
oracle db, oracle database, rman: Hi Kalaiselvan, http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1219816_tax299411,00.html?bucket=ETA&topic=299411 It is recommended that you don t use TOAD to perform the backup of your database. Rather, you can use tools...

Oracle: ORACLE error 20015, oracle error, oracle application
oracle error, oracle application, application administrator: Hi, ORA-06512: // *Cause: Backtrace message as the stack is unwound by unhandled // exceptions. // *Action: Fix the problem causing the exception or write an exception // handler for this condition. Or you may need to contact...

Oracle: ORACLE SQL PLUS VERSION 9 LOGIN PROBLEM, database configuration assistant, oracle sql
database configuration assistant, oracle sql, oracle forums: Hi Marvin, http://forums.oracle.com/forums/message.jspa?messageID=1079515 The above link has a step-by-step checklist of things to check. The cause of the error that you are seeing is simple ... Oracle SQL*Plus does not know which database instance to...

Oracle: Oracle, correct username, rebecca
correct username, rebecca, oracle: Hi Rebecca, you can try something on these lines - The query should be like - SELECT Username, Password FROM tablename WHERE Username = Username AND Password = Password If the above query returns any row then the user is validated...

Oracle: Oracle 10g, oracle dba, salery
oracle dba, salery, rman: Hi there, The basic Oracle administrative work has not changed all that much between 8, 9, and 10g. However, there are subtle changes in each release when new features are used. The basic DBA administration will help and work in most versions of Oracle....

Oracle: Oracle 10g, oracle home, export utilities
oracle home, export utilities, oracle 10g: You need to use import/export utilities for the same. Use Export utility which is available in $ORACLE_HOME/bin its name will be exp . It creates a dump of either a particular user or database or database objects in specific ( depending on the options you...

Oracle: Oracle 10g, oracle 9, system tablespace
oracle 9, system tablespace, set compatibility: Good day, I will try to answer your question as best as I can, giving that the question is a little bit vague or unclear what you are trying to do. If I may, I want to rephrase the question. You have a corporate database, and you want to dump all the...

Oracle: Oracle 10g db down often, ms sql server, sql server stored procedure
ms sql server, sql server stored procedure, ms sql server 2005: Hi Vladimir Fri Dec 14 14:10:09 2007 Memory Notification: Library Cache Object loaded into SGA Heap size 2201K exceeds notification threshold (2048K) KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw== This is a warning that your database requires more...

Oracle: Oracle 10g installation, oracle 10g documentation, oracle 10g database
oracle 10g documentation, oracle 10g database, external networking: Hi Peter, The major difference between XP Professional and XP Home is in the communications packaging. XP Professional allows for external networking while XP Home does not. If your intent is to run this on a stand-alone PC with a stand alone application,...

Oracle: Oracle 10g - loosing connection, oracle 10g, oracle 9i
oracle 10g, oracle 9i, database backup: HI Laura, I would check the Process Scheduler logs. These logs are produced on the server where the Process Scheduler components are installed (sometimes co-located with the Tuxedo Application Server). The log file is typically called ULOG.YYYYMMDD and...

Oracle: Oracle 10g & SAN, database oracle, oracle 10g
database oracle, oracle 10g, order of magnitude: Hi Martesha, There s no hard and fast rule in terms of how to size your production database. Oracle does provide some guidelines and suggestions here: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/build_db.htm#i16367 It goes without...

Oracle: Oracle 10g version for PC Home, oracle enterprise manager, mainboard asus
oracle enterprise manager, mainboard asus, database configuration assistant: Hi Van, After (assuming default) installation, you should have received a dialog box that provided all the information to access the Oracle Enterprise Manager (OEM) via your web browser. The link below should provide and show all the necessary steps...

Oracle: Oracle 10g, oracle technology network, rollback segments
oracle technology network, rollback segments, oracle 8i: Hi Sandeep, On the surface of it, 10g is not all that much different from 9i, especially if you re using only the basic components. What s different between 9i and 10g, is the changes to the how Oracle manages the database. In 10g, the database is fully...

Oracle: Oracle 11I conversion, oracle 11i, cant answer
oracle 11i, cant answer, functional aspect: Hi toni i have worked on an implementation and currently doing support and enhancements. as for implementations its a very complex process which i cant answer, coz there are lot of areas to cover which i dont specialize in, to start with the functional...

Oracle: Oracle, relational concepts, relational databases
relational concepts, relational databases, pl sql: Hi, I think a good way to start is to learn about relational databases. It´s essencial that a good DBA know´s the relational concepts. Certifications, in my concepts, will just make you hireble (I mean that, with a certification you...

Oracle: Oracle, first oracle, archive operation
first oracle, archive operation, change description: Hi Shinil, You ve got an interesting problem. Symptoms Following errors are reported in the alert log file: ORA-354: corrupt redo log block header ORA-353: log corruption near block 1892904 change 281470950178815 ORA-312: online log 5 thread 1:...

Oracle: Oracle, oracle 9i new features, oracle 8i
oracle 9i new features, oracle 8i, oracle corp: Hi Khushi, Some easy to follow reference on this topic: http://www.geekinterview.com/question_details/22717 http://forums.oracle.com/forums/thread.jspa?messageID=1662428 What is the difference between Oracle 8i and Oracle 9i? Brian Peasland: Oracle...

Oracle: Oracle, microsoft sql server, infrastructure hardware
microsoft sql server, infrastructure hardware, network software: Hi Kunal, It depends on what type of infrastructure (hardware, network, software license, etc.) that you have or will be investing in. If your budget is tight, you might want to consider some lower cost alternative such as MySQL (relatively free) to commercial...

Oracle: Oracle, database replication, oracle db
database replication, oracle db, ors: Hi there, http://www.akadia.com/services/ora_replication_guide.html http://www.dbasupport.com/oracle/ora9i/ors.shtml Are two good start for understanding and implementing Database replication. With Oracle 10g, you can now use Data Guard (included free...

Oracle: Oracle 7.3.4 installation on Sco Unix, sco unix, oracle product
sco unix, oracle product, oracle 7: Hi there, FOr your first question, You may wish to check certification of Oracle 7.3.4 on Sco Unix 6.x. For your second question: INSTALLATION OF ORACLE 7.3.4.0.0 ON SCO OPENSERVER 5 FAILS ==========================================================...

Oracle: Oracle 7.3.4 installation on Sco Unix 5.0.6, oracle server manager, ms windows platforms
oracle server manager, ms windows platforms, sco unix: Hi there Srichan, The software that you installed is compiled but requires to be linked with the OS libraries before they become executables. The only exception is if you are on a MS-Windows platforms (in this case everything is compiled and linked in advance)....

Oracle: Oracle 8.0 on Unix with D2K, oracle 8, hindi fonts
oracle 8, hindi fonts, oracle server: Hi Vipul, I ve enclosed two reference for you as I m not sure which version of Hindi you may be using. Reference: http://www.mid.main.vsu.ru/docs/oracle/server.816/a76966/ch3.htm#46887 Character Set: http://staff.in2.hr/denis/oracle/nls_data.html...

Oracle: Oracle 8i Archive Logging Problems, oracle 8i database, oracle home
oracle 8i database, oracle home, service pack 4: Hi Trevor, Have you taken a look at your Trace (.TRC) files or alert logs for any other detailed error messages? They should be located (using the Oracle OFA architecture) in $ORACLE_HOME/oradata/bdump/ .... You should see in either, espeically the ALERT.LOG...

Oracle: Oracle 9.2.0.5 64-bit patch, metalink oracle, oracle 9
metalink oracle, oracle 9, pdf documentation: Hi Kamal, There are no PDF documentation for the Oracle 9.2.0.5 (64-bit) patch set. If you have access to metalink.oracle.com, you can find a list of alerts and known issues. If you re looking for installtion information, you may want to try technet.oracle.com/documentation....

Oracle: Oracle 9i to 10g, depth detail, b simple
depth detail, b simple, water marks: Hi Hozefa, Enclosed is the link to Oracle s Upgrade Guide (http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm). There are two ways to upgrade your database: 1. (Original) Export from 9i and IMPORT to 10g. 2. Use the Database Upgrade...

Oracle: Oracle 9i database and Oracle 9i Application server., oracle enterprise manager, oracle 9i database
oracle enterprise manager, oracle 9i database, third party software: Hi, There are a number of places that you can check to see where the latency is occuring. But the number one question that you have to determine, WHERE is the latency occuring (the cause)? Is it because of the (a) application; (b) database; (c) OAS; (d)...

Oracle: Oracle 9i installation on windows XP profesional, oracle 9i installation, server workstation
oracle 9i installation, server workstation, computer properties: Hi there, You may want to make sure that you ve got FULL admin privilideges on your XP server/workstation. Second, make sure you ve got the latest JRE (1.4.2 is the latest version). Finally, when you right-mouse click on your My Computer | Properties |...

Oracle: Oracle 9i, inactive chapter, oracle 9i
inactive chapter, oracle 9i, oracle database: Hi Malru, I m not sure in what context you are referring to. I will assume that you are referring to connections to an Oracle database. A session is ACTIVE when it is making a SQL call to Oracle. A session is INACTIVE if it is not making a SQL call to...

Oracle: Oracle Applications, gl module, oracle applications
gl module, oracle applications, report thanks: u have answered part of ur question ur self as u r new u need help and thats normal, everyone learns the same way. as for on ur own u can use the e-TRM (Technical Refernce Manuals) which u can get from metalink or on the CD s of apps documentations ...

Oracle: Oracle (Basics), oracle rdbms, oracle basics
oracle rdbms, oracle basics, application architect: Hi, Oracle RDBMS is the Oracle Database. The database is capable of storing vast information. Usually there is an application that interacts with the user to capture (store) or display (retrieve) the data. There are commercial products from Oracle such...

Oracle: Oracle Capacity Planning, pl sql, oracle database
pl sql, oracle database, table structures: Hi Suchitra, Basic capacity planning should take into account the following: 1. Table structures and the max length of each row. You can use the average length of each row, if you have sufficient data populated. 2. Determine maximunum number of rows...

Oracle: Oracle Certification, oracle certification, oracle 10g
oracle certification, oracle 10g, pl sql: Oracle 10G has started working with grid applications, it´s the big difference, and of course those little differences, such as changing the binary write and read. But a difference is that if you has DBA 10g you will be the top of the market and if you...

Oracle: Oracle Certification., human resource database, oracle certification
human resource database, oracle certification, peoplesoft application: Hi Marc, To get an Oracle certification, you need to take the Oracle certification exam. You can find out about the different exams here: http://www.oracle.com/education/certification/starthere.html I have been working as a DBA for the last 10 years...

Oracle: Oracle Character set, production stock, oracle database
production stock, oracle database, application data: Hi, As far as Oracle database is concerned, you will get the string as it is stored in the table. So if it is stores as stockie, it will be retrieved by the same spelliing unless you give the % which specifies any characters. You can try the query using...

Oracle: Oracle Configuration, sqlplus nolog, realm error
sqlplus nolog, realm error, orcl: hi roderick sorry for the delay can u try the following start the database from the services panel of windows, then come to the dos prompt, assuming u created the default database with name orcl, if not then give the name of the database. c: set...

Oracle: Oracle Connection, oracle connection, oracle server
oracle connection, oracle server, sql syntax: Hi Erwin, When trying to connect to Oracle via ODBC, you need to provide the userid, password and database that you are trying to connect to. The SQL syntax to connect to Oracle is generally: username / password @ database . Some things you need...

Oracle: Oracle commit, sql code, pl sql
sql code, pl sql, pseudocode: Hi Edson, Because Oracle treats the transaction as a unit of work, it won t commit until the transaction, in this case an INSERT is completed. You can, however, write some PL/SQL code that uses loops and force commit points at certain interval. In...

Oracle: Oracle Database Backup options, oracle 9i database, oracle utilities
oracle 9i database, oracle utilities, base oracle: Hi Rohit, Oracle database comes with two types of popular and easy forms of backup, three implementation. Oracle does provide other means (see other resources at the bottom). 1. Oracle Database Export. This create a .DMP file that contains the data within...

Oracle: Oracle / DBA, oracle 9i dba handbook, sql programmer
oracle 9i dba handbook, sql programmer, oracle dba: Hi Antony, There are a number of great books for DBAs. Most of them are from the Oracle Press (http://www.amazon.com/exec/obidos/tg/detail/-/0072193743/qid=1088425715/sr=1-5/ref=sr_1_5/002-2238669-6728850?v=glance&s=books). This one is Oracle 9i DBA Handbook....

Oracle: Oracle DBA 10G Certification Guide/Manual, oracle dba, oracle 10g
oracle dba, oracle 10g, certification books: Hi Abdul, The link below is a list of Oracle 10g DBA Certification books that is available for purchase from Amazon.com http://www.amazon.com/s/ref=nb_ss_b/104-6219679-1225558?url=search-alias%3Dstripbooks&field-keywords=Oracle+10g+OCP&Go.x=0&Go.y=0&Go=Go...

Oracle: Oracle DBA, oracle dba, creation wizard
oracle dba, creation wizard, oracle forms: If you are using Oracle 9i release 2(9.2.x), it comes with a database creation wizard that asks you some basic questions and based on your answers, creates it for you. To create it manually, there is a lot of work invovled. To develop forms, you can use...

Oracle: Oracle database 7.3.4, metalink oracle, oracle 8i
metalink oracle, oracle 8i, oracle 7: Hi Darrell, Oracle 7.3.4 is no longer supported on AIX 5L platform (including 5.1 and higher). The mimimum version supported on AIX 5.1 is Oracle 8i. You may wish to try to upgrade the OS on a non-production database platform server. However should you...

Oracle: Oracle database space issue, oracle 9i, using oracle
oracle 9i, using oracle, database space: Hi Eric, It depends on how badly defragmented your tablespace. If you have a lot of free space but are scattered all over the place (this might be a result of a massive delete from your tables), then you might opt to just coalesce. Run this query (from...

Oracle: Oracle Error, kind reply, oracle error
kind reply, oracle error, oracle support: Hi Faisal, I m afraid I don t quite understand question #2. Could you please elaborate? As for question #1, your error is a rather serious error. You must contact Oracle Support (via metalink, email or telephone) to report this error. Source: http://ora-00600.ora-code.com/...

Oracle: Oracle Forms 9i, urgent query, oracle forms
urgent query, oracle forms, oracle developer: Hi Beenish, you might check out the following links and see if it helps- http://www.oracle.com/technology/documentation/forms.html http://www.oracle.com/technology/sample_code/products/forms/index9i.html http://www.oracle.com/technology/products/forms/pdf/269054.pdf...

Oracle: Oracle Help, ms access database, oracle help
ms access database, oracle help, oracle objects: Hello, 1) You can coppy the two tables using export/import utility of oracle. First export the two tables using following command export scott/tiger It will ask for many options. When asked for backup of whole user/tables/all users, give the...

Oracle: Oracle Help, ms access database, oracle help
ms access database, oracle help, oracle objects: Hi, You cannot copy the tables of a Oracle Database. There is a process called export and import that has to done to replicate the DATABASE only. In Oracle without knowing the login id and password, no person can open up the database. Of course the...

Oracle: Oracle home, oracle home, oracle products
oracle home, oracle products, oracle 9i: Hi Mousa, Glad to hear your question with genuine frankness. An Oracle home is the place in system (SGA) where Oracle products run. This area consists of the directory location where the products are installed(ora_home) , the system path setup,and the...

Oracle: Managing Oracle Users, uk oracle, oracle users
uk oracle, oracle users, index command: Hi Jaswinder, The user created with the identified externally clause is mainly used for the operating system authentication. eg. create user abc identified externally; This will authenticate the operating system user abc to login to the database user...

Oracle: Oracle Installation, oracle installation, oracle 9i
oracle installation, oracle 9i, terminal version: Hi Vikas, Oracle 9i (9.0.1) is no longer supported by Oracle. The latest and terminal version of the Oracle 9i is the 9.2.0.8. You can still download 9.2.0.1 and then patch it up. In terms of certification of Oracle 9i and platforms (i.e. OS and hardware),...

Oracle: Oracle Installation, oracle 8i, ahmad 1
oracle 8i, ahmad 1, sqlplus nolog: hello ahmad u r password file may have got corrupted and there are bugs associated to the error ORA-01017 as well, u can do the following, provided its ur personal database and not a production system. c: oradim -delete -sid ur db name c: oradim...

Oracle: Oracle Installation, oracle 8i, oracle installation
oracle 8i, oracle installation, oracle home: Hi Ahmad, The installation of Oracle 9i on Windows 2000 is as simple as follow the instructions that show up on the java installer. With the TNS error, you may want to check the TNSNAMES.ORA file, located under %ORACLE_HOME%NETWORKADMINTNSNAMES.ORA....

Oracle: Oracle JDeveloper, oracle jdeveloper, integrated development environment
oracle jdeveloper, integrated development environment, visual basic programming: Hi Gerry, Oracle JDeveloper is an integrated development environment with end-to-end support for modeling, developing, debugging, optimizing, and deploying Java applications and Web services. The latest version of the JDeveloper deployed by Oracle is...

Oracle: Oracle jobs and learning sequence, oracle education, oracle management
oracle education, oracle management, preferred books: Hi Rohit, Mastering the ability to manage and maintain an Oracle database as a DBA requires a lot of knowledge of the internals of Oracle and experience working with the database. The salary depends, of course of the market and if there is a high demand....

Oracle: Oracle & Linuk, otn oracle, linux index
otn oracle, linux index, oracle 9i: Hi Sumaia, http://otn.oracle.com/tech/linux/index.html is the link for all the installation on LINUX. YOu ll find it at the bottom of the apge. Check out the DOCUMENTATION button at the top of the page for other versions of Oracle. Hope this helps. ...

Oracle: Oracle Logon, parkar, orant
parkar, orant, logmain: hello srini u need to create an ON_LOGON trigger and need to handle the calls there for login u will have a code something like this if :user_name is null then null; else check logon built in help for using LOGON built_in u need to use it here....

Oracle: Oracle locking on Unix V/s Windows, rdbms oracle, oracle rdbms
rdbms oracle, oracle rdbms, roby sherman: I agree with you, but here goes an article for better explain: In support of Oracle Linux Roby Sherman performed an exhaustive study of the speed of Oracle on Linux and Microsoft Windows using identical hardware. Sherman currently works for Qwest Communications...

Oracle: Oracle migration tool, oracle migration workbench, ms access database
oracle migration workbench, ms access database, oracle databases: Hi Rohit, You can chose either option, which ever best suits your requirement. With Option 2, the MS-Access database is tied to the availability of the Oracle database, regardless if it s a stand alone or networked application. Option 1 gives you some...

Oracle: Oracle ODBC connection to MS Access, oracle odbc, odbc configuration
oracle odbc, odbc configuration, odbc source: Hi Barry, If you have admin privileges, you can configure your ODBC to add a new ODBC source called Oracle. You will need to ensure you have the Windows drivers required to connect to Oracle. Once configured (including user, password and database connection...

Oracle: Oracle PL/SQL, pl sql, oracle server
pl sql, oracle server, startup shutdown: Trigger is a PL/Sql block of code which is executed automaicaly by oracle server upon occurance of certain predefined events.hese events are startup, shutdown, insert, update, delete, login, logoff etc. for e.g. you want to create a new pension account...

Oracle: Oracle Query, system privileges, database schema
system privileges, database schema, oracle database: Hi, You can use TOAD for checking all the objects in a database (You must have system privileges). 1) Alternatively you can use the dba_objects table to list the names of all objects. 2) To view the procedure/function/package, you can use dba_source...

Oracle: Oracle querry, oracle 9i new features, oracle rdbms
oracle 9i new features, oracle rdbms, oracle 10g: Hi Dhirendra, No formal information about Oracle RDBMS 11i / 11g has been released. Oracle 9i New Features http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96531/toc.htm Oracle 10g R2 New Features http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14214/toc.htm...

Oracle: Oracle query, varchar2, man age
varchar2, man age, nvl: select a.col2, mastval, c.keyval from master_temp a, child_temp b, transact c where a.col1 = b.keyid(+) and a.col1 = c.keyid group by a.col2, mastval, c.keyval union select a.col2, b.keyval , (select nvl(c.keyval, ) from transact...

Oracle: Oracle query, employee database, column names
employee database, column names, oracle: Hello, Sorry. Gave you the wrong query. This is the right query (Please check the column names as per emp table) select empno, ename, join_date from emp where join_date = (select min(join_date) from emp); Hope this helps you Regards Suchitra...

Oracle: Oracle Reports, oracle reports, zeros
oracle reports, zeros, decimals: Ernesto, Try it out this way TO_CHAR (TO_NUMBER (TRIM (result_value)), 9999.99 ) Examples: SQL SELECT TO_CHAR (TO_NUMBER (TRIM ( 0.50 )), 9999.99 ) FROM DUAL; TO_CHAR( -------- .50 SQL SELECT TO_CHAR (TO_NUMBER (TRIM ( 0.50 )),...

Oracle: Oracle SQL, oracle sql, select sum
oracle sql, select sum, doc id: hello jason u can use the following query select publication,sum(decode(deleted,1,1,null)) Val1 ,count(deleted) Total Del from doc_test d group by publication having count(deleted)=(select sum(decode(deleted,1,1,null)) from doc_test d1 where...

Oracle: Oracle SQL help, oracle sql, schema name
oracle sql, schema name, oracle book: Hi Jen, query 1. select a.sname, a.sal from staff a where a.sal (select sal from staff where sname = SONG ) query 2. select a.sname, a.SAL, a.MGR, (SELECT SNAME from staff where staffid = a.mgr) sname, a.STAFFID, ( SELECT sal from staff...

Oracle: Oracle Unix shell script, unix shell script, sql insert command
unix shell script, sql insert command, oracle unix: Hi, You can call sql queries from unix shell script as follows sqlplus -s usr/pwd EOF x1.log select * from emp; exit EOF In above eg. usr/pwd is username and passwd for db (schema). The output will be logged in x1.log. Hope this helps ...

Oracle: Oracle SQL Query., full table scan, oracle sql
full table scan, oracle sql, database principles: Let´s go, You said: For ex.: select expr ,* from dual. But, this fails too. It fails, if, expr is an aggregation! Because aggregations needs the group by clause! But if you do select a ,* from dual; It works. Every...

Oracle: Oracle SQL Software, oracle program, oracle sql
oracle program, oracle sql, sql course: Hello John U can refer the oracle press books and also oreilly press books on the subjects. and for the software u need to install oracle on your pc, oracle is freely available for learning purpose from the oracle web site, http://otn.oracle.com Thanks...

Oracle: Oracle Start, oracle 9i, oracle 8
oracle 9i, oracle 8, orcl: Hello i m using 10g at home and i m able to use net start as follows C: net start oracleserviceorcl The OracleServiceORCL service is starting.................. The OracleServiceORCL service was started successfully. still if it does work...

Oracle: Oracle service suddenly stopped., oracle 9i database, oracle service
oracle 9i database, oracle service, oracle services: Hi Rohit, 1. Can you login to the database as SYSDBA or with the /NOLOG. If you can, can you issue the command: SQL SHUTDOWN ABORT; This will force the database to be shutdown completely. 2. Next stop all Oracle services from Windows XP. Make...

Oracle: Oracle Trigger Error, oracle trigger, loop exception
oracle trigger, loop exception, select count: Try this: CREATE OR REPLACE TRIGGER studentfive AFTER INSERT OR UPDATE OF studentno ON enrolment DECLARE violation INTEGER; toomanycourses EXCEPTION; BEGIN for c in (select count(studentno) cont from enrolment group...

Oracle: Oracle table creating, oracle table, academics
oracle table, academics, oracle: Hello, If you require any guidance for the creation of tables, I can give you anytime. But as this is your school project, you have to learn the syntax of creating table and then do it yourself. Money is not important than knowledge. So no question...

Oracle: Oracle training, oracle technet, otn oracle
oracle technet, otn oracle, oracle training: Getting to know Oracle is quite a mouthful... I Suggest you search amazon.com with the keywords Oracle and beginner A very useful resource is Oracle TechNet at http://otn.oracle.com - click Getting started in the top line menu. As for the...

Oracle: Oracle and web, oracle forms, oracle application
oracle forms, oracle application, using oracle: Hi Lora, .FMX files are created using Oracle Forms (using Oracle Forms 4 to 6i or Developer 2000, or a later version of Developer). While you can access the application via the web, you cannot do any development changes via the web. You would need to use...

Oracle: Why Oracle???, sybase rdbms, unix mainframe
sybase rdbms, unix mainframe, database management systems: Hi There. It s a matter of preference. Oracle and IBM s DB2 are the two largest enterprise-based databases. Oracle s RDBMS can be run on any platform (Unix, Windows, Mainframe) where IBM s DB2 is better suited for some platforms (AIX Unix, Mainframe). Microsoft...

Oracle: Oracle8i, Visual Basic6, visual basic6, using visual basic 6
visual basic6, using visual basic 6, readable format: Hi Madhu, That depends on what your intent is for. If you want it only to be able to perform a disaster recovery, then you may wish to consider talking to your DBA to perform and EXPORT (backup) and Import (restore). Be advised that this will render the...

Oracle: Oracle9i installation, default port number, oracle home
default port number, oracle home, hr database: Good day Ramesh In order for you to access an Oracle database, you will need to setup your tnsnames.ora. TNSNAMES.ora is a SQL*Net configuration file that defines the database connection information. TNSNAMES.ora can be found in %ORACLE_HOME%/network/admin...

Oracle: Oracle9i question, rental id, rental values
rental id, rental values, line member: Hello, You can check the errors for package first using SHOW ERRORS. The main error I see is that you are declaring 2 procedures and 1 function in package specification. But you are writing only 2 procedures in the package. The function should also be...

Oracle: OracleServices, ms windows platform, oracle rdbms
ms windows platform, oracle rdbms, oracle services: Hi Malru, http://www.orafaq.com/faqwinnt.htm#services is a good starting reference point. The service to which you are alluding to are for background processes that are required by Oracle when running on a MS-Windows platform. With Oracle 10g, there...

Oracle: Orcale, database trigger, col1
database trigger, col1, string length: Hi Prakash, I am not sure whether this will work, but still you can give it a try. Write a database trigger as follows - create or replace trigger tab1_trig before insert on tab1 for each row begin :new.col1 := substr(:new.col1,1,10); end;...

Oracle: LEFT OUTER JOIN, oracle odbc, oracle 9
oracle odbc, oracle 9, lucian: Hi Lucian, try this - SELECT AWARD_ENTRY.AENT_COMPANY, AWARD_ENTRY_CREDIT.AENC_LAST_NAME, AWARD_ENTRY_CREDIT.AENC_FIRST_NAME FROM AWARD_ENTRY LEFT OUTER JOIN AWARD_ENTRY_CREDIT ON AWARD_ENTRY.AENT_SEQNO=AWARD_ENTRY_CREDIT.AENC_AENT_SEQNO HTH...

Oracle: Outer Joins., dname, loc
dname, loc, 7788: Mark: Consider the classic example SQL SELECT * FROM dept; DEPTNO DNAME LOC ---------- -------------- ------------ 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40...

Oracle: object type query, type sql, type query
type sql, type query, contact address: Hi Philip, it should be something like this - create or replace type personal_details_type as object ( title varchar2(10), firstname varchar2(20), surname varchar2(20) ); / create table tblPersonalDetails ( SSN varchar2(10),...

Oracle: operations on one table reflecting on other table automatically, f1 new, two tables
f1 new, two tables, snapshots: Hi, You can create trigger for this as follows before insert or update or delete on emp1 for each row begin if inserting then insert into emp2 values (:new.f1, :new.f2 ....); elsif updating then update emp2 set .... elsif deleting...

Oracle: your opinion........., oracle courses, oracle books
oracle courses, oracle books, performance backup: Hi, If you had Oracle in your academics then it is easy to pick up. Else you have to start from scratch and learn the basics SQL, PL/SQL, and Oracle. I would suggest you take help of the SQL, PL/SQL or Oracle books and start practicing. B coz unless...

Oracle: ora-01536 space quota exceed (Urgent), schema name, expert friend
schema name, expert friend, indx: Hello, Though I am not an expert in this area, I would advise you to try this out ALTER USER username QUOTA UNLIMITED on TBS_AC_INDX; (where username is your schema name which is using this tablespace) Hope this helps you. Regards Suchitr...

Oracle: ora-12560, listner, oracle database
listner, oracle database, experts exchange: Hi Vico, Enclosed is a detailed step for cloning an Oracle database. It should include the detailed steps for creating the services. You can follow the steps in this link as a guide to see if there is a missed step. If all else fails, you may have to undo...