i want to show all the sales from tha data i have, that meet the
following criteria:
- Product category is A or C and VAT is 12%
- The supplier serial number (the last part after the ".") is odd.

Is it possible to partitioning nested tables? I mean, I have a large
table with some columns as nested tables, the main table is
partitioned, can I partition the nested tables too?
Thanks

I have done this before, but it's been awhile and I am stumped and am
missing something simple here. I have columns in table a that need a num
value changed from a 4 to a 3 where they are 4 and also meet a join
condition in another table. First I make a query that returns the

Core question:
I'd like to execute this statement as "appuser":
ALTER INDEX adminuser.my_oracle_text_index REBUILD;
Error message:

I am new to Oracle and I installed the Oracle 10g Express Edition on
my windows machine.
Immediately after installation, it worked great and I was able to look
at the tables etc. But after a few days, I cannot seem to log in to my

I was talking with fellow DBA that told me that I should export my
schema, drop it, and re-import it.
The reason was that it would act as a defragment and would reorganize
my extents and therefore I would gain better performance.

I'm playing with Oracle 10g Regular Expressions.  I have a string that
looks like this, basically a comma delimited string:
z      VARCHAR2(40) := '1:3,4:6,8:10,3:4,7:6,11:12';
What I want to do is basically parse this string.  This this example,

I am looking to pull weekly stats from daily data, but am not sure the
best way to accomplish this. I would provide a start date, and then I
am looking to pull the last 52 weeks of data based on a start date. So
if I choose 1/18/2008 then I would get summed daily data for 1/12/2008

I'm trying a compile a proc but the run would just go forever and
throw 'ORA-04021: timeout occurred while waiting to lock object xxx'
at the end. Upon checking the v$session_wait, i found "latch: cache
buffers chains" as Event and "Concurrency" as Wait_class. On checking v

In my 10gR2:
SQL> select extent_management, segment_space_management,
tablespace_name from dba_tablespaces;
LOCAL      MANUAL SYSTEM

I am less than a novice on Oracle so I am sorry for such a simple
post.
A client has given me dmp files of their data.  I have installed
Oracle 11g to import the dmp files so I can then transfer them to my

I understand what this MAXBYTES column (DBA_DATA_FILES) means for an
autoextensible datafile. What I don't know is the meaning of this
column when the datafile is NOT autoextensible. Also, how is this
value initialized/changed by Oracle for this kind of datafile?

I need to move 490 records from a column named TRACKID to PS_NAME.
After I do that I need to also set STATUS_CD to "RETIRED" and insert
NULL values where the TRACKID used to be.  I have succesfully found
the 490 records with the following select statement:

Hi to All,
I have in my 'schema' 2 tables:
CREATE TABLE T_ITEMS
(

Oracle 10g Express Edition on Suse 10.3 Linux, KDE 3.5.7
Downloaded the RPM and installed ok.
Following the 'get started' instructions and one of the first steps is
to click on the 'Go to Database Home Page' option in the Oracle Menu.