MOVE Tables from One Tablespace to Another Tablespace !!

Hello All, Please tell me the detailed steps to move tables from one tablespace to another tablespace. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: MOVE Tables from One Tablespace to Another Tablespace !!

8i - alter tbale move tablespace new_tbs -- From: Dash, Saroj (CAP,CEF)[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Subject: MOVE Tables from One Tablespace to

Re: raw devices

Raw versus filesystem is almost a religious issue. There are very good arguments both ways. The main advantages of filesystems are ease of use and flexibility. I tend to favor raw devices for critical production systems - for write-intensive OLTP at least. For development and functional test

Re: Using Table Partitions in 8.0.5

It gets worse... Partitioning is an additional cost option - even with Enterprise Edition. -Don Granaman [certifiable OraSaurus] - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Monday, August 20, 2001 12:32 PM Subject: RE:

RE: MOVE Tables from One Tablespace to Another Tablespace !!

hi, the command is : Alter table table_name move tablespace tablespace_name; But be careful from index corruption. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]] Envoyé : mardi 21 août 2001 08:16 À : Multiple

Significance of TWO_TASK

Hello All, Can anyone tell me what is the significance of the env variable TWO_TASK? when and where it is used etc ? Thanks in advance Uma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, UmaSankara S (CAP) INET: [EMAIL PROTECTED] Fat City Network Services

Disaster recovery

I have to document our Oracle databases for the case where I'm e.g. hit by the proverbial bus. So if you DBA folk were to come on site to pick up the tab and start managing our databases what information would you like to be able to refer to, to allow you get up to speed as quickly as possible

No errors showed in the DBA Studio

Hello list, Oracle 8.1.7. NT4.0 I have created some procedures in the DBA Studio, and when I try to compile them I get that the procedure status is Invalid, but in the 'show error' window there is no message. The window appears but it´s completely empty. Could somebody tell me what happens? Do i

Re: read and insert

Hi friend Currently I' doing a procedure to read about 60 column more from a table and insert into another tables.. Since most of the table insert involve is 3 tables only.. will it be better I build up 3 procedure /function , so that everytime I just pass in the variable and let the

Re: MOVE Tables from One Tablespace to Another Tablespace !!

Hi, 1. Export the tables in 1st tablespace 2. drop the tables from 1st tablespace 2. import the tables into 2nd tablespace or alter table tablename default tablespace tablespacename rukmini - Original Message - To: Multiple recipients of list ORACLE-L

Re: RE: raw devices

Hi! With support for different file systems apart from 'ufs' like jfs and vxfs Much of the perfomance issues have been covered. In fact apart from Oracle Parallel Server having datafiles,redo log files and controlfiles on raw devices does NOT make much sense. Particularly with

Re: MOVE Tables from One Tablespace to Another Tablespace !!

Hi, in the 2nd option , you have to use move instead of default. i.e. alter table tablename move tablespace tablespacename rukmini - Original Message - To: [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 1:51 PM Hi, 1. Export the tables in 1st tablespace 2. drop the

Re: MOVE Tables from One Tablespace to Another Tablespace !!

Before importing, make sure you set the schema owner's quota to 0 for the first tablespace. Otherwise, import will create the tables in the first tablespace again. Dennis Rukmini Devi wrote: Hi, 1. Export the tables in 1st tablespace 2. drop the tables from 1st tablespace 2.

RE: Significance of TWO_TASK

TWO_TASK is like ORACLE_SID, but it directs Oracle clients to resolve via TNS rather than looking for that SID directly via BEQ. So, if my SID is TEST on the local machine, and I do: $ export ORACLE_SID=TEST $ sqlplus system/manager I will connect to the instance with a SID of TEST on the

RE: Significance of TWO_TASK

Thanks a lot Guy for the explanation -Original Message- Sent: Tuesday, August 21, 2001 6:11 AM To: Multiple recipients of list ORACLE-L TWO_TASK is like ORACLE_SID, but it directs Oracle clients to resolve via TNS rather than looking for that SID directly via BEQ. So, if my SID is

RE: Freelist Contention

Raja: You will know you have freelist contention if you have a significant buffer busy waits ratio (5%). Jon Walthour -Original Message- Luthra Sent: Monday, August 20, 2001 11:45 PM To: Multiple recipients of list ORACLE-L Hello folks, How do I come to know that there is a

Re: How to sign-off this group?

Please read the bottom of any e-mail on this list! Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 20, 2001 3:04 PM Would some one please

Re: No errors showed in the DBA Studio

Here's a radical thought. You could actually go into sqlplus and do a select from the dba_errors or user_errors view. I realize that this is will cause many on this list to think of me as a dinosaur, ready to be relegated to the old DBAs home, but come on, if you are going to call yourself a

Spool 32 Error

We recently have Spool 32 Error message appear on almost all of computers when user request printing. Could anyone share the experience why and how to solve this problem. Thx. Warmest regards, Le Quang Huy Manager -- Information Technology Chinfon Manulife Insurance Company Limited Diamond

SQL Question

Greetings! I don't see a lot of general sql questions on this list, so if this is the wrong place to post this sort of thing, just let me know! This will hopefully seem like a simple question, but I am a relative novice in sql programming! Here is the (simplified) scenario with three tables:

RE: changing long to lob

Jon, sorry it was a 9i thing. joe [EMAIL PROTECTED] 08/20/01 10:10PM Joe: Can you tell me if you were able to do this? I just tried it and it errored out on me: SQL create table test_lob (col1 varchar2(30), col_lob long); Table created. SQL desc test_lobName Null?

RE: DBA tasks

Y'know, like Captain Kirk in Star Trek does. This is a wholesome family mailing list!! g -Original Message- Sent: Monday, August 20, 2001 6:52 PM To: Multiple recipients of list ORACLE-L At 01:38 PM 8/20/2001, Rachel Carmichael wrote: ahem... get the girl lol well, now,

Re: w2k scripting

Lisa - Use perl. Thats the nice thing about perl, it runs on almost all OS's. And its FREE :) Gene [EMAIL PROTECTED] 08/20/01 12:37PM Lisa, I use Tcl and OraTcl that comes with Oracle Enterprise Manager. Chaim Koivu, Lisa [EMAIL PROTECTED] on 08/19/2001 05:15:21 PM Please respond

RE: changing long to lob

In 8i you can use ... (straight from SQL reference manual) TO_LOB Purpose Converts LONG or LONG RAW values in the column long_column to LOB values. You can apply this function only to a LONG or LONG RAW column, and only in the SELECT list of a subquery in an INSERT statement (see INSERT on page

Re: SQL Question

Hi, How 'bout not like these querries will always use a full tablescan though. Quicker ways? maybe the oracle context search or something like that anyway, but I've never used it. Jack

RE: SQL Question

Your method is correct. The only issue is if you are processing huge amount of data, this will take some (may be lot of) time. You can use not like option for DO NOT contain query. ... where title not like '%word%' rgds amar -Original Message- Sent: Tuesday, August 21, 2001 5:06 PM To:

RE: Converting EBCDIC to ASCII

Thanks for the information. How does your mainframe guy get the data out of IMS? Thanks, Ken We do not pull data directly from IMS but load it in batch jobs. Our mainframe guy either dumps the data report-style (ASCII) or copies records in native EBCDIC to files on the mainframe. We ftp

High DML Table - I/O Suggestions???

Sorry to repost this, but I just lost all of my email from the past two days. Arghh! I have a table that is ~100Mb in size. The table will always contain 500,000 to 1,000,000 records in it at any given time and approximately that number of inserts, updates and deletes will be performed against

Re: Converting EBCDIC to ASCII

Thanks for the help. How did you create the flat files? How did you get the data out of IMS and into the flat files? TCP/IP or SQL Loader or what? Thanks, Ken I did it by creating flat files containing only character data (no packed fields), and using sqlloader to load the data. I

Re: net 8 / 8i ?

Darren, Paul has made some excellent points. Just keep in mind that only versions 8.1.6 and later are supported on Win2K. I'm not saying earlier versions *won't* work (I have the 7.3.4 client running on Win2K), only that if you find yourself in a situation where you're getting bizarre

User access within/outside of app

List, We have purchased a system where users login through an ODBC connection using a generic Oracle userid. This userid has full rights to do insert, update, delete, select on any table in the schema. The app asks for another username and password which checks the application security table,

Re: Converting EBCDIC to ASCII

Thanks for the help. Oracle will be located on a W/2000 box. Could you go into more detail on how one exports data from IMS on the mainframe to flat textfiles? Thanks, Ken If you export the IMS data out to flat textfiles, and then transfer them via ftp in ASCII mode, the

Re: Spool 32 Error

because there isnt 32 days in any month, sounds like a windoze error. joe [EMAIL PROTECTED] 08/21/01 09:30AM We recently have Spool 32 Error message appear on almost all of computerswhen user request printing. Could anyone share the experience why and howto solve this problem. Thx.Warmest

RE: DBA tasks

Sorry, but that made me think of a funny site. I found this a while back, it's pretty funny reading. http://www.grudge-match.com/History/ensign-stormtrooper.shtml It's the red shirt dudes from star trek that always die when they go down to a planet vs the storm troopers who couldn't hit the

Apologies... linux Oracle

Title: Apologies... linux Oracle Sorry everyone, I know you were just discussing this recently. What is the most stable combination of Oracle Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember. Thank you Lara Croft Oracle Database

foreign key constraints

Let's say I had two tables: CREATE TABLE t1 ( col1 NUMBER PRIMARY KEY); CREATE TABLE t2 ( col2 REFERENCES t1(col1), col3 VARCHAR2(40)); Then I ran the query: select a.table_name, b.table_name, b.column_name from user_constraints a, user_cons_columns b where

Nolog writes log ?

Hi, I have Emp table NOLOGGING. Does it write to log files the insert,update,delete activity on that table ? Tia Aldi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official

RE: Freelist Contention

Bufer busy waits can also be caused by parallel query servers trying to read the same buffer block at the same time. So does it always indicate a freelist problem? . --- Jon Walthour [EMAIL PROTECTED] wrote: Raja: You will know you have freelist contention if you have a significant buffer

RE: Freelist Contention

You have to learn to listen to your database, grasshoppa'. A good alternative to the Buddhist and kung fu techniques is the v$waitstat table. If you see accumulating time for 'extent map' or 'free list', then you know that you have to rebuild the table with more free lists. To see the actual

What is in archive log...

Hi Lister, Can we read what activities are in archive log files ? (utility like 'tkprof' to read trace file). Tia. Aldi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official

Re: Recovering WITHOUT tablespaces - 2001-08-16

I was bitten but this badly and thanks to all those people who helped me. This may some of you, so I'm posting it. Scenario: I wanted to extract one table as of a time the previous day. So I decided to recover to the closest time as possible before the unwanted change was made. This meant

Re: What is in archive log...

Read Docs about LogMiner. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 11:41 AM Hi Lister, Can we read what activities are in archive log files ?

oracle training

Hi, DBAs Just wonder if there is any good oracle training programs for oracle performence tuning, backuprecovery etc. ? thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

We got Some Error ( Forget the Exact Error Number NOW ) on Oracle 8.1.7.1 with CURSOR_SHARING=FORCE We Applied the Patch 8.1.7.2 the Error was Resolved -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:58 PM To: Multiple

Re: Memory Sizing

Did you maybe use a different init file? Did you check the parameters in your email from sql or from the init file you think you're using to start the database? Just a sanity check, I'm sure you did all the right things... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: How do they get the answer?

an assumption is made that the same 2 teachers are not teaching subject 102 and 105 for if they were then, only 2 teachers would be getting raises. but if you go with 4 different teachers are teaching that class(2 groups of 2) then answer c would be correct. I think C SHOULD say at least 2

RE: SQL Question

- - Your method is correct. The only issue is if you are processing - huge amount - of data, this will take some (may be lot of) time. You can use not like - option for DO NOT contain query. - ... - where title not like '%word%' If you are suggesting a query such as: select id from biblio

RE: SQL Question

Bill You can do this with intermedia text, but I wouldn't recommend it unless: a) your tables are big; b) you need to do this all the time; and c) doing it the way you suggested is too slow. Essentially, this involves creating an IMT index on biblio.title that actually indexes biblio.title,

RE: foreign key constraints

Actually, I have it: select a.table_name, b.table_name, b.column_name, c.column_name from user_constraints a, user_cons_columns b, user_cons_columns c where a.r_constraint_name = b.constraint_name and a.constraint_name = c.constraint_name and b.column_name != c.column_name and

Re: No errors showed in the DBA Studio

Yea but what happens when you need to perform something that you dont have a gui tool for? then you really will look like a BAD(and no not bad slang as in good) DBA. joe [EMAIL PROTECTED] 08/21/01 12:01PM A lot of thanks Rachel,it helps me a lot, although I would prefer to use a GUI tool

RE: How do they get the answer?

Title: RE: How do they get the answer? My thoughts are Typical OCP question. a) Could be the answer depending on if both the subjects are taught by the same 2 teachers b) Cannot be the answer because only 2 subjects are mentioned (102,105) c) Could be the answer if the 2 subjects are taught

RE: MOVE Tables from One Tablespace to Another Tablespace !!

But make sure you rebuild indexes afterwards. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton

Re: No errors showed in the DBA Studio

A lot of thanks Rachel, it helps me a lot, although I would prefer to use a GUI tool (despite of looking like a bad DBA). Thank you, Rachel Carmichael wrote: Here's a radical thought. You could actually go into sqlplus and do a select from the dba_errors or user_errors view. I realize that

RE: Freelist Contention - PQ slaves

Title: RE: Freelist Contention - PQ slaves I thought that parallel query slaves were smart enough to divide up the work between them so there was no overlap? What am I missing? Can you elaborate? -Original Message- From: Johnson Poovathummoottil [SMTP:[EMAIL PROTECTED]] Sent:

RE: Apologies... linux Oracle

Title: Apologies... linux & Oracle Lisa SuSe is the best so I have been told. I am about to install 8i on 7.1 and another guy here is installing 9i on 7.2. Totally untested on my behalf as I haven't started yet but that is the best I have been told. Probably of no use whatsoever !!! Lee

How do they get the answer?

I am taking the Self-Test software test for the SQL exam and don't see how they get the answer to this problem. They don't explain how it is arrived at. Any help you can give me will be appreciated. Thanks, Ken Janusz, CPIM -- Examine the structure of the

Re: No errors showed in the DBA Studio

I'm not morally opposed to GUI tools... and using them doesn't make you a bad DBA. But I really think that you (generic you) need to understand what the tool is doing, so that if you end up somewhere that doesn't have and won't buy the tool, you can still do your job. From: Beatriz Martínez

Re: How do they get the answer?

I think you're being tricked by the question. If each subject is taught by two or more teachers, and you're updating the salaries of all teachers teaching two subjects, 2 x (2+?) = 4 Brian [EMAIL PROTECTED] wrote: I am taking the Self-Test software test for the SQL exam and don't see how

RE: Spool 32 Error

See http://www.computerhope.com/issues/ch000373.htm http://www.completeclinic.com/sn_spool32.html Rick -Original Message- Sent: Tuesday, August 21, 2001 9:31 AM To: Multiple recipients of list ORACLE-L We recently have Spool 32 Error message appear on almost all of computers when

Re: Nolog writes log ?

yes. i've tested it and you should too. joe [EMAIL PROTECTED] 08/21/01 11:21AM Hi,I have Emp table NOLOGGING.Does it write to log files the insert,update,delete activity on that table ?TiaAldi_Get your FREE download of MSN

Re: What is in archive log...

Check out the Oracle 8i Administrator's Guide, look at the chapter entitled: Using LogMiner to Analyze Online and Archived Redo Logs. Jon Walthour From: Aldi Barco [EMAIL PROTECTED] Date: 2001/08/21 Tue AM 11:41:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

Re: RE: Freelist Contention

No. Just because you have a high bbw ratio, that doesn't indicate strictly a freelist problem. However, having problems with freelists often results in a high bbw ratio. Jon Walthour From: Johnson Poovathummoottil [EMAIL PROTECTED] Date: 2001/08/21 Tue AM 11:21:02 EDT To: Multiple

Exporting partitioned tables

Greetings and salutations oh magnificent Oracles of Oracle, I am experiencing something that I don't understand. (No comments from the peanut gallery!) When I do an export for a schema that contains a number of partitioned tables most of the time everything works fine. Sometimes however,

DB size question?

Hi If redo log files are multiplexed in database. In computation of Database size is multiplexed redo log files size would be consider or not? Thanks -Seema _ Get your FREE download of MSN Explorer at

Re: What is in archive log...

Aldi, You can use LogMiner to view activity in the archive logs. See Note:111886.1 for how to set it up. Traci Rebman Database Administrator DE Communications, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Traci Rebman INET: [EMAIL PROTECTED] Fat City

Re: What is in archive log...

Hi Aldi You can use Logminer ! Aldi Barco wrote: Hi Lister, Can we read what activities are in archive log files ? (utility like 'tkprof' to read trace file). Tia. Aldi _ Get your FREE download of MSN Explorer at

RE: How do they get the answer?

two subjects in the in clause, times at least two teachers per subject equals at least four records updated. sometimes it is easier to eliminate answers first. like, you can throw out d) syntax will occur. and b) all teachers will get an increase. you are then left with a) two teachers and c).

RE: Apologies... linux Oracle

Title: Apologies... linux & Oracle O.K...it looks like SCO was bought by Caldera, who sells a distribution of Linux under that name. Ed -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 12:36 PMTo: Multiple recipients of

Re[2]: How do they get the answer?

I think someone had difficulties with word problems in Math class. Gotcha again!! Dick Goulet Reply Separator Author: Brian McGraw [EMAIL PROTECTED] Date: 8/21/2001 8:57 AM I think you're being tricked by the question. If each subject is taught

Re: Freelist Contention

On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote: Bufer busy waits can also be caused by parallel query servers trying to read the same buffer block at the same time. Just off the top of my head, and without giving it a lot of thought, this doesn't sound right. PQS divvy up

9i Via Oracle 8 ODBC Drivers?

Greetings, Current Client: NT Workstation 4.0, w/ Oracle 8.00.05.00 ODBC driver and SQL*Plus Rel 8.0.5.0.0 Current DB Server: Oracle 8.0.6.0.0 EE for HP-UX 11.0 Will our current client config work with 9i databases? If not, what driver, SQL*Plus client, or other config changes would be

RE: How do they get the answer?

Each subject is taught by at least 2 teachers. So, if 102 and 105 are the 2 subject-ids, then a total of at least 4 teachers will get selected for salary update. Correct ? Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original

Re: High DML Table - Suggestions??

I have a big table too, about 16GB. It is a vert static one(customer table), will add data once in it, but queried all the time, and do the segmentations against it all the time. It also has 12 indexes. Right now , the performance is ok. Any special consideration for such a big table. Thanks,

Re: Nolog writes log ?

Aldi, How did you create a table as NOLOGGING. The fine manual states that you can use nologging only on a table created with the select as clause. The fine manual also states that you can create a table based on a query without generating redo log entries. Keep in mind that in the event of a

Re: What is in archive log...

what version of Oracle? but yes, read the manuals on logminer From: Aldi Barco [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What is in archive log... Date: Tue, 21 Aug 2001 07:41:32 -0800 Hi Lister, Can we read what

Re: How do they get the answer?

in the where clause, the IN says any teachers that are in any of these subjects. Since there are two subjects in the IN set and at least 2 teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise. Jon Walthour From: [EMAIL PROTECTED] Date:

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

Eeeek! It just keeps getting worse! Can someone on 8.1.7.x on a NON-HP platform using CURSOR_SHARING=FORCE and CBO at the system level try the following test for me? -- DROP TABLE REJ_TEST CASCADE CONSTRAINTS ; CREATE TABLE REJ_TEST ( ACCESSCONTROLID NUMBER (10)

RE: Apologies... linux Oracle

Title: Apologies... linux & Oracle SCO makes a version of Linux now? Ed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 11:51 AMTo: Multiple recipients of list ORACLE-LSubject: Apologies... linux Oracle Sorry everyone, I

RE: linux Oracle -- best combination

Lisa and others, About a year ago, I was working for a company as a Linux systems engineer (Read as: Tech guy doing sales support). Most of our customers wanted Linux systems, and it was my responsibility to provide them the correct combination of Linux and hardware to meet their needs.

DB2 Question

Does DB2 store data as EBCDIC or ASCII? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Re: User access within/outside of app

Create another user with select privileges only on the objects in the app's schema. Give that one to them and then change the password on the original app id so they won't be able to use that one anymore. Jon Walthour From: Larry Hahn [EMAIL PROTECTED] Date: 2001/08/21 Tue AM 11:21:04 EDT

Re: How do they get the answer?

Well, to me it looks like WHERE subject_id IN (102, 105);will select 2 classes. Since there are a minimum of 2 teachers per class, this will select at least 4 teachers. Am I missing something? Stephen [EMAIL PROTECTED] 08/21/01 09:25AM I am taking the Self-Test software test for the

Re: Performance analysis (enqueue and buffer busy waits)

Does that mean you think it is impossible to have rollback segments that are too big ? Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See

RE: No errors showed in the DBA Studio

Likewise, I always believed that if you had to use DOS, then you have a better understanding of how Windows operates, because it has to go through DOS to reach the hardware. Assembly language is useful too, if you like headaches. Another reason to learn the command line is that GUI tools very

RE: Apologies... linux Oracle

Anyone have luck with 9i on RedHat? I am sure the answer is yes as people has mentioned trying. Do they have it documented what is needed to be done to accomplish this? Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and

Index question ???

Hi, all I got couple of indices questions: Is it REQUIRED or just recommended to build an index on FK column/s? I used Alter Table ... Move and Alter Index ... Rebulid to move the table into differenct block and then rebuild index. Table Move works fine, but after index rebuilt, some indices

Re: Exporting partitioned tables

quickly looking at metalstink, it appears quite often with an ora-600 message, got one of those in the alert.log? joe [EMAIL PROTECTED] 08/21/01 12:35PM Greetings and salutations oh magnificent Oracles of Oracle, I am experiencing something that I don't understand. (No comments from the

RE: linux Oracle -- best combination

I would be curious to see these tests going forward, seeing as RedHat support is difficult to do with 9i and such. And suse now being Oracle's perfered linux. I wonder if these results have changed. I never really played with Oracle on Linux, but if I ever had to, I would be curious. Do not

Re: Nolog writes log ?

Joe, I do not have the ability to test it at my sight. Would you test this and respond. Thanks, Oracle Performance Tuning Tips Techniques Page 538. Subject NOLOGGING: It specifies whether subsequent direct loader (SQL*LOADER) and direct-load INSERT operations against the table, partition, or

RE: How do they get the answer?

Title: RE: How do they get the answer? Ken, after reading through the quesiton and thinking it through I arrived at the answer they give. They are trying to trick you into choosing syntax error. You'll find questions similar to this on the exams. Lara Croft. Certified Tomb Raider and DBA.

RE: How do they get the answer?

What if there are only two teachers among all teachers that teach both the (specified) subjects ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: Apologies... linux Oracle

Title: RE: Apologies... linux Oracle Dunno... I know even less about Linux than I do about perl and smtp. LK -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 13:31 To: Multiple recipients of list ORACLE-L Subject: RE:

RE: Freelist Contention - PQ slaves

Another thing that comes to mind is incorrectly tuned DBWR, which cannot keep up. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 2:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Freelist Contention - PQ slaves

8.1.7/HP-UX 11/PRODUCT_USER_PROFILE

Hi All: I have entries in the PRODUCT_USER_PROFILE to inhibit a user from executing the DROP command. However, if I embed a DROP command inside a PL/SQL procedure, and execute it with Dynamic SQL, the DROP is executed. Is this normal? Thanx, Mike ---

Re: How do they get the answer?

At least 2 teachers per subject and the where clause has 2 subjects in the query. 2 teachers X 2 subjects= 4 minimum. ROR mô¿ôm [EMAIL PROTECTED] 08/21/01 12:25PM I am taking the Self-Test software test for the SQL exam and don't see how they get the answer to this problem. They don't

RE: MOVE Tables from One Tablespace to Another Tablespace !!

I just did this yesterday. Here are the scripts I used; sqlplus system/syspaswd set pagesize 0 set feedback off spool mv_tbls.sql select 'alter table '|| owner || '.' || segment_name || ' move tablespace new_tblspc;' from dba_segments where segment_type='TABLE' and

User access within/outside an app

List, We have purchased a system where users login through an ODBC connection using a generic Oracle userid. This userid has full rights to do insert, update, delete, select on any table in the schema. The app asks for another username and password which checks the application security table,

RE: High DML Table - Suggestions??

Walter, Couple of other areas to watch while DMLs are being issues against this table are: LGWR and DBWR statistics and activities. Based on DBWR/LGWR statistics, you may need to tune these parameters. Jay -Original Message- Sent: Monday, August 20, 2001 5:31 PM To: Multiple recipients

RE: TNSPING Test Script for NT

Ed, how about: tnsping {sid} 1000 ping.lis will tnsping the {sid} 1000 times, with the result being placed in a file created named ping.lis changing it to *** file name pingtest.bat tnsping %1 1000 ping.lis Can be executed as pingtest {sid} Another way to do this using a loop within

Problem in setting up Pro*C on RedHat Linux 6.1 with Oracle Serve

Hey all, My system is RedHat 6.1 and installed oracle version is 8.05. Database is running fine. But I was trying to check if Pro*C is setup properly. I am getting the following errors when I try to compile the sample programs. I am able to compile C programs successfully using cc command. Can

  1   2   >