|
Solution Search:
How can I open the Database Configuration Assistant (DBCA) in Oracle 10g Express Edition and how can I download the DBCA? The DBCA is a program installed when you install the Oracle software. You cannot download it. I've never used the Express Edition, but if the DBCA utility is not present in ORACLE_HOME/bin, then that edition does not use the DBCA. Understand how to install the DBCA in Oracle...
More...
Jun 22, 2009
How can I transform the indexes of a table when we are transferring that table from one schema to another schema? You can use the DBMS_METADATA.GET_DDL to generate the CREATE command to recreate the Oracle index in the other schema. Spool the output to a file, and you have all you need to recreate the index!. Something similar to the following is a start:
SPOOL create_my_index.sql SELECT DBMS... More... Jun 18, 2009
We originally installed Oracle 9i on an AIX box, where we also installed our application. However, we now want Oracle installed with Pro*C. So is there any patch available to just install the Pro*C option with Oracle, or do we need to reinstall Oracle and select the Pro*C option during installation? We cannot risk reinstalling Oracle, as it may affect our front-end application, so please let me...
More...
Jun 18, 2009
I have exported an Oracle 9i database (UNIX - Solaris) and I need to import it to an Oracle 9i database on a Windows server. I am using the Enterprise Management Console on the Windows server to do the export and import. The exported file is approx. 300 MB in size.
The exported file seems to be OK, however when importing the file, the data files in the target database increase far beyond what I... More... Jun 18, 2009
When I export and then import a user using the Oracle 8 client, the triggers of the tables are not imported. Can you help? If you want to ensure the triggers are exported, add the TRIGGERS=Y parameter to your export command. Otherwise, without seeing the exact import and export commands, I am not sure what problem is arising. Are your Oracle triggers not importing after an Oracle export? Learn...
More...
Jun 18, 2009
What is the difference between an Oracle database repository and information repository? At first glance, they might be the same things. And one may use a database to be its information repository. But these are two different things.
An information repository is a store house for information. This information can be unstructured or have a free form. The data in the information... More... Jun 18, 2009
Does Oracle require a license for a development database? This is probably an issue that gets many companies in hot water during an Oracle audit. The short answer is yes, you must purchase a license in most cases. However, if you download the Oracle Standard Edition, Standard Edition One and the Enterprise Edition from the Oracle Technology Network (OTN), you can develop on the OTN software...
More...
Jun 9, 2009
I need to upgrade an Oracle 9i R2 database and the DB size is 25 Terabyte. The operating system is Solaris 9. What strategy do you recommend I adopt? For a database that size, I recommend using the Database Upgrade Assistant (DBUA) for your database upgrade. The Upgrade Guide contains details on how to perform this upgrade. Pay attention to Chapter 3 which details how to use the DBUA for the...
More...
Jun 5, 2009
Why is it that when I restore my Oracledatabase, some of the function/procedures are invalid objects? If you performed a full restore, then you should not have invalid objects in Oracle. When you do a partial restore, you may be dropping tables (during the restore operation) that are needed by the function or procedure. The object that depended on this table is then made invalid. Once the...
More...
Jun 5, 2009
How do I trim the Oracle listener log? My database is 24*7 and if I move the file I have to bounce the listener. In Unix/Linux servers, I do the following:
cp listener.log listener_copy.log The above makes a copy of the listener log and then overwrites the log with an empty file, thus zeroing out the log's contents. If you do not need the old copy, you can remove it, or skip the... More... Jun 5, 2009
In previous Q/As, you mentioned that you are careful when using the Oracle Grid Provision and Patching functionality. We are just getting started with it and would like to understand why you are cautious. Is there some particular database characteristic that causes problems? Are there specific things we need to avoid using Enterprise Manager to deploy patches? Thank you so much for...
More...
Jun 4, 2009
How do you create multiple schemas for the same user account in Oracle? Is it possible or not in Oracle? It is not possible. In Oracle, a user = a schema. When you create an Oracle user, it is tied to the schema with the same username. You cannot create any additional schemas for that user. Instead, just create another user! If the first user needs to "see" the new user's schema, you can grant permissions...
More...
May 20, 2009
I have created a view and it is fetching the data properly. Then I used that view in four to five "Crystal Reports". In three reports it is opening properly, but in one report it is showing the ORA-00904 error. Can you help? The ORA-00904 error is saying that you have specified an invalid identifier. This identifier could be the view name, or could be as simple as a syntax error. I would venture to say...
More...
May 20, 2009
When I am trying to connect to the Oracle database through Toad, I am getting the error ORA:12514 TNS: listener does not currently know service requested in connect descriptor. Can you help me? You need to look at your database listener's properties. On your database server, do "lsnrctl status". It will list the services the listener supports. The ORA-12514 error is saying that you specified a...
More...
May 20, 2009
I am working in a retail unit project and about 1,000 outlets are going to be rolled out with Oracle Database Standard Edition. My question is about the requirement for automating Oracle patching. Can I use Oracle Enterprise Manager 10g Grid Control with Oracle Standard Edition? If not, then how can I automate the patching of 1,000 outlets? Deploying and managing 1,000 installations of...
More...
May 20, 2009
I have two Oracle Apps instances (Oracle database 9i) in a single Linux server. How would I connect both databases from SQL Plus while the username and password are the same? As you have probably figured out, SQL*Plus can only connect to one instance at a time. If you want to query the other instance, you will create a database link from the first instance to the second instance. This download...
More...
May 7, 2009
We have a nightly batch job that refreshes the data warehouse tables. The PL/SQL and SQL code is very old ( from 2002). It runs OK in 9i, but when we test in 10g some of the UPDATE statements are extremely slow. The job runs forever, so we have to kill the job. How would you go about the problem? Are there any parameters that you would change? It is not uncommon for an SQL statement in one major version to...
More...
May 7, 2009
I am using Oracle 10g (Release 1). I have taken a table export from a schema which is in Oracle 9i (9.2.0) using the exp command, and it successfully completed without warnings. But when I import into my Oracle 10g server from the same export file, it is giving the following error:
IMP-00003: ORACLE error 1917 encountered May 7, 2009
I am working on a DoD project. We need to apply security patches on 120 remote databases and we are not allowed to use the Oracle EM--GUI interface. So my question is, do you know any third-party tools that have functions that can apply patches to remote database worldwide? It means this tool has to be enterprise edition and have the kind of repository to register all remote server/database...
More...
May 7, 2009
We have a 3TB Data Warehouse on Oracle 10g R2 database on IBM AIX 5.2 OS. We are in the stage of rebuilding a new test/disaster recovery (DR) environment which we want to use as DR and test environments. We would like to refresh the full 3TB of data on a regular basis for system testing, as well as set up some kind of DR on the same server. Is there any fast way of shipping 2TB of data across to the test...
More...
May 7, 2009
I have a database dump from the Oracle 9i Std version and I created a new database (installed the same version) in another PC. The dump file is to be imported in the new database . What should be done in a new database before starting the import? The command used to expprt and importare:
exp ucs/ucs file=path log=path compress=y grants=y statistics=none imp ucs/ucs file=path log=path fromuser=ucs... More... May 7, 2009
What happens if the database buffer cache is not big enough to hold the data from a query (like a big table scan)? Oracle will read in parts of what it needs into the buffer cache to satisfy the query, then clear out those buffers to read in more of what it needs. The process may repeat until the query is done processing. The smaller the buffer cache, the more this has to happen, and your queries may...
More...
May 7, 2009
I'm trying to drop a broken datafile in my Oracle 10g using this:
ALTER TABLESPACE "TABLESPACE" DROP DATAFILE '/sata/oracle/db_1/oradata/ORCLM7/spacefiles/spacefiles_8' But I always get the following error: ORA-00060: deadlock detected while waiting for resource I drop all tables/packages which belong to this datafile. This datafile is on offline mode. Can you help? I have never dropped a... More... May 7, 2009
How would I merge multiple varchar2 rows into one row of type CLOB?
Example:
create table A (keys number, text CLOB); insert into B values (1, 'How do I '); insert into B values (2, ' merge multiple rows '); insert into B values (3, ' into one row of type CLOB? '); After inserting from table B into table A, I would like to see the following after selecting from table A: keys text ----- ------- 1... More... Apr 16, 2009
Can I use a variable in place of table name in a SELECT Statement?
Example : define a = 'EMP'; SELECT * FROM &A; Substitution variables only work in SQL*Plus or SQL*Worksheet, because those tools know about substitution variables. This is OK for a one-off script you're running manually. For automation, it's not so good because it'll sit there at a prompt waiting for input. Since you define the... More... Apr 16, 2009
|
Oracle Content
Oracle Solutions
|