Search results for query: *

Thank you again. For some reason, I must use Oracle Express.

Thanks. DBCA does not exist in Express. I am doing it on my own computer to try a new process. I want to see how to copy a database(Express version) from another machine to my machine without reinstall. And my machine needs to have db_1, or db_2, or db_3 depends on what I need. What is the...

Hello, I need to drop and create database in Oracle10g Express version. I have to deininstall and install Oracle Express in order to achieve this. Can I drop and create database in Oracle Express? How to do it? Thank you.

thank you. I am all set

Hello, I need to import all objects in "scott" schema from DB1 to DB2, I need all objects, including table definiations, constraints, stored functions/packages and etc, everything in this schema except data. I do not need any data from any table, not a single row. Can I do this in sqlplus? If...

Thanks to everybody for your time. Santa, "set timing on" helps. but if the data is already in cache, and I run my new method using same dataset, the result will not be accurate. What do you think? Dagon, materialized view will not work for my situation because the data is dynamic for each...

Hello, I have a big view which has very complicated busness logic. The cost of the execution plan(explain plan for) is very high. If I rewrite this view to a stored procedure that calculates for each field and store the value to an interim table, I believe it will improve the performance...

Never mind, dbms_fga.add_policy works for me.

All I need is to find out if this table is used at all.

Hello DNG, Can you post your solution here?

Hello, I want to check if a table(table_a) will be used in next 2 months and who is using it. Here is what I want to do: create a trigger on select on table_a insert into table_log(sysdate, user,sql_text); But trigger can not be created on select, How can I achieve this? Thank you

Thank you LKBrwnDBA. It works for me. Here is the trigger I wrote: CREATE OR REPLACE TRIGGER trg_ddl_check_name_length AFTER CREATE OR ALTER ON SCHEMA DECLARE oper VARCHAR2(30); sql_text ora_name_list_t; i PLS_INTEGER; obj_name VARCHAR2(100); v_owner...

Hello, Oracle allow table name length to 30 and column name length to 30. I need to limit the table name and column name size to 27 for any new tables and new columns in my database. Can I write a trigger on create table and new column to check the size? How can I do it? Thank you in advance.

Hello, I want to add a index to a large table table_1(state_code, customer_num, other_col) I want to add an index like : CREATE BITMAP INDEX IDX_bitmap_1 ON table_1(state_code, customer_num) TABLESPACE base_index ; As you know, state_code is only 52, but this table has billions of rows...

Thanks to everybody for your help. I tried all your suggestions and none of them worked for my case. Then I read Oracle Database Installation Guide: "2.4.1 Installing Oracle Database on DHCP Computers" and installed Loopback Adapter Now it works without any problem. Thank you again.

Hello, I got answer from Oracle metalink, it says that "the schema document is not well formed". and the document is fixed now. Thank you very much. this can be closed.

my data base is Personal Oracle Database 10g Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining option

Hello, I am exploring SQL/XML in 10g. I found this article is very helpful for me: http://www.oracle.com/technology/pub/articles/quinlan-xml.html So I followed the instruction and practice on my local machine(local personal 10g database). It workded fine until I got stuck here: BEGIN...

Thank you William. I will do it later.

two times. I could not open Database control URL from first install after reboot my machine, I thought I missed something during installation, so I deleted all files I could from db_1 folder(there is no way to uninstall). Then I installed again(which is db_2 folder). Then I still can not open...