Search results for query: *

I do not need the triggers to fire in my IMPORT. The source database will be EXPORT'ed then shut down. The target database will be IMPORT'ed... procedures/triggers/views re-compiled, then the database opened up to the users.

Hi there. Your post caused me to think about the manner in which I am (was) importing. Before I did the import, I was running a script (in effect) that would create all my objects in the target database first.... I did this because my tablespace names are different in 9i, and I wanted to...

I am migrating a 6GB database from 8.1.7.4 to 9.2.0.4. The hardware is Sun v450's running Solaris 9. I use the 8.1.7.4 EXPORT command to create my dump file. I have no tables with LONG's. I use the 9.2.0.4 IMPORT command to load the dump file, using the following syntax: IMP file= full=y...

There's an easier way. Use Oracle EXPORT to dump the table to a file. RTFM on how to export just a table. Using SQL*PLus or TOAD, create the table in the target database with the unique constraint. Then, on the target system use Oracle IMPORT to load the table. Any duplicate keys will get...

I have found no hard-and-fast answer for our problem. We narrowed it down to one or two tables in the database, and we deleted the statistics for these tables (so queries against these tables always run using RULE-based optimization). I also created a schedule to rebuild all my indexes at...

I have a Sun E450 with 2GB RAM, running Oracle 8.1.7.4. I have 10 Oracle instances running on this machine. I am no Solaris expert, but what I can tell you is that your semaphore settings should be directly proportional to the total number of Oracle "processes" (as defined in each...

Hi there. I am attempting to get Yahoo Messenger running on Solaris 5.8, on a Ultrasparc Enterprise 250. Has anyone done this successfully? The problem I am having is this -- Yahoo Messenger starts up OK, but when I try to edit any preferences, it core dumps. I'm pretty sure I have all the...

I just came across Ximian Evolution - it is a UNIX-based app that looks and feels just like Microsoft Outlook. With the "Connection" option, it can connect to an Exchance server like any other Windows machine. I've installed it on my Sun box, and it works great! http://www.ximian.com

I am the de facto DBA of a smaller database (200 tables, 12GB total, data plus indexes). We are running 8.1.7.4 on a Sun Ultrasparc 450. We moved to this platform back in September, 2001, and not had any problems until the last 30 days. Twice in the past month now, the CBO seems to lose its...