Maximo

Hi Group, I have a Maximo system moving into production, using Oracle 816/Sun solaris If anyone has experience, from DBA point of view, what I should be care of? anything to change/check? any particular table? Thanks James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Drop schema and all related objects

connect as sys or system. drop user username cascade; The user and all objects will be removed. james --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related

Table last updated data

Does Oracle capture a last updated date whenever a table update occurs? Or do I need to create a trigger to handle this? Thanks... D. James Stein Senior Developer/Database Engineer [EMAIL PROTECTED] 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 x165 Cell: 941

Re: NOLOGGING creates txns in redo/archive logs

This is normal. When a transaction is set to nologging, minimal redo is written because of Data Dictionary changes that are occurring. James --- [EMAIL PROTECTED] wrote: I have been testing logminer and noticed that when I alter a table to NOLOGGING, txns are still recorded

Re: Insert from a table to another

You can do a simple insert/select statement within pl/sql declare begin insert into table_a (select * from table_b); end; / if all the columns are in the same order in both tables. If not list the columns out. James --- [EMAIL PROTECTED] wrote: Any one whom can give me a good advice

Re: Need feedback on 9iAS

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James

Re: Q: Oracle Year End???

ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Cold Fusion and Oracle

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network

Priv to view package bodies created by other users

bodies created by other users you need the "create any procedure" system privilege. To view type bodies created by other users you need the "create any type" system privilege. Are there any object level privileges that would accomplish this request? TIA for your help, Debb

Re: index query

You could use the alter index rebuild option. This keeps the old index available for queries until the new index has been created. You just need to make sure you have double the space of the object you are rebuilding when using this technique. James --- Seema Singh [EMAIL PROTECTED] wrote: Hi

Re: Meeting at IOUG

e official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

How to wrap old sqlplus reports with Java and output html

if possible. Any suggestions sqlj, XML, etc... TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: FOREIGN KEY to a remote table. Is it possible?

This is not possible. It is possible to enforce referential integrity via a trigger over a database link. James --- Andor Gyula [EMAIL PROTECTED] wrote: HI, Is is possible to create a FOREIGN KEY constraint that references to a remote table through DATABASE LINK? Thanks in advance

Slightly off topic SFTP

automated. Suggestions? TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Re: Metalink customer satisfaction surveys

t you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: Insert

to be very fragmented and eventually you will need to rebuild it to reclaim unused space. james --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Hi DBA's, One of my developers just asked me a question, and honestly I don't know what he's talking about. But, it made me think of my own that I do

Re: Script to know the size of each table in a schema ?

/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Can not open DB :(

You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Receiving I/O errors in Oracle 8.1.7 on Compaq Tru64 5.0a UNIX

We are in the process of migrating our databases from Oracle 8.1.6 to Oracle 8.1.7 on the Compaq Tru64 UNIX platform with 5.0a OS. When we bring one database (test instance) over to the 8.1.7 Oracle Home and attempt to start the database we are receiving multiple I/O errors that appear to go

pro*c install ?

DBA's, Can anyone give me some tips on installing/configuring pro*c on AIX/8.1.6. I've looked at the install manual, technet, metalink, etc??? ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network

RE: Speed up import of a 10gb table with a long_raw datatype

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: On-Call - terms, conidtions and perks!

-L FAQ: http://www.orafaq.com -- Author: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMO

<    1   2   3