moving tables to a different tablespace

2001-07-26 Thread Rusnak, George A. 

Hi Group,
Please explain what I am doing wrong.
1)  exp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
3)  Created tablespace outln_ts on webprod
4)  Altered user outln default tablespace outln_ts
5)  imp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
6)  SQL> select table_name, tablespace_name
   from dba_tables 
   where owner = 'OUTLN';

  TABLE_NAME TABLESPACE_NAME
--
--
 OL$SYSTEM
 OL$HINTS   SYSTEM
 XX
OUTLN_TS

WHY are the tables being re-imported back into SYSTEM tablespace 

Oracle 8.1.7 on Sun Solaris 5.7

TIA

Al Rusnak
804-734-8453
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rusnak, George A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: moving tables to a different tablespace

2001-07-26 Thread Kevin Kostyszyn 

Is it possible that the original user that the export was taken from was in
the system tablespace?  Try doing a FROMUSER/TOUSER
kk

-Original Message-
George A.
Sent: Thursday, July 26, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L


Hi Group,
Please explain what I am doing wrong.
1)  exp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
3)  Created tablespace outln_ts on webprod
4)  Altered user outln default tablespace outln_ts
5)  imp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
6)  SQL> select table_name, tablespace_name
   from dba_tables
   where owner = 'OUTLN';

  TABLE_NAME TABLESPACE_NAME
--
--
 OL$SYSTEM
 OL$HINTS   SYSTEM
 XX
OUTLN_TS

WHY are the tables being re-imported back into SYSTEM tablespace 

Oracle 8.1.7 on Sun Solaris 5.7

TIA

Al Rusnak
804-734-8453
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rusnak, George A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: moving tables to a different tablespace

2001-07-26 Thread Ron Rogers 

did you set the quota for the user to use the new tablespace and revoke the SYSTEM 
tablespace?
If you did not try to control where they were allowed to go then the imp would put 
them back where they came from.
Did you imp with IGNORE=Y?
just a thought.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 07/26/01 01:50PM >>>
Hi Group,
Please explain what I am doing wrong.
1)  exp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
3)  Created tablespace outln_ts on webprod
4)  Altered user outln default tablespace outln_ts
5)  imp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
6)  SQL> select table_name, tablespace_name
   from dba_tables 
   where owner = 'OUTLN';

  TABLE_NAME TABLESPACE_NAME
--
--
 OL$SYSTEM
 OL$HINTS   SYSTEM
 XX
OUTLN_TS

WHY are the tables being re-imported back into SYSTEM tablespace 

Oracle 8.1.7 on Sun Solaris 5.7

TIA

Al Rusnak
804-734-8453
[EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rusnak, George A.
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: moving tables to a different tablespace

2001-07-26 Thread Jon Walthour 



George:

I think you need to do a fromuser/touser export/import here.

Jon Walthour

>--- Original Message ---
>From: "Rusnak, George A." <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/26/01 1:50:41 PM
>

>Hi Group,
>Please explain what I am doing wrong.
>1) exp outln/outln@webprod   file=exp_file
>tables = 'OL$' 'OL$HINTS'
>2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
>3) Created tablespace outln_ts on webprod
>4) Altered user outln default tablespace outln_ts
>5) imp outln/outln@webprod   file=exp_file
>tables = 'OL$' 'OL$HINTS'
>6) SQL> select table_name, tablespace_name
>  from dba_tables 
>  where owner = 'OUTLN';
>
> TABLE_NAME TABLESPACE_NAME
>   --
>--
>OL$  
 SYSTEM
>OL$HINTS   SYSTEM
>XX
>OUTLN_TS
>
>WHY are the tables being re-imported back into SYSTEM tablespace

>
>Oracle 8.1.7 on Sun Solaris 5.7
>
>TIA
>
>Al Rusnak
>804-734-8453
>[EMAIL PROTECTED]
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Rusnak, George A.
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling 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: Jon Walthour
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: moving tables to a different tablespace

2001-07-26 Thread Deshpande, Kirti 

Hmmm... .
Dealing with 'OUTLN' may cause problems. Please search Metalink for 'OUTLN'.
You may have to log an iTAR with Oracle to recreate it in a different
tablespace (or moving it to a different tablespace).   

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Jon Walthour [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 2:31 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: moving tables to a different tablespace
> 
> 
> 
> George:
> 
> I think you need to do a fromuser/touser export/import here.
> 
> Jon Walthour
> 
> >--- Original Message ---
> >From: "Rusnak, George A." <[EMAIL PROTECTED]>
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Date: 7/26/01 1:50:41 PM
> >
> 
> >Hi Group,
> >Please explain what I am doing wrong.
> >1)   exp outln/outln@webprod <mailto:outln/outln@webprod>  file=exp_file
> >tables = 'OL$' 'OL$HINTS'
> >2)   Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
> >3)   Created tablespace outln_ts on webprod
> >4)   Altered user outln default tablespace outln_ts
> >5)   imp outln/outln@webprod <mailto:outln/outln@webprod>  file=exp_file
> >tables = 'OL$' 'OL$HINTS'
> >6)   SQL> select table_name, tablespace_name
> >from dba_tables 
> >where owner = 'OUTLN';
> >
> >   TABLE_NAME TABLESPACE_NAME
> > --
> >--
> >  OL$  
>  SYSTEM
> >  OL$HINTS   SYSTEM
> >  XX
> >OUTLN_TS
> >
> >WHY are the tables being re-imported back into SYSTEM tablespace
> 
> >
> >Oracle 8.1.7 on Sun Solaris 5.7
> >
> >TIA
> >
> >Al Rusnak
> >804-734-8453
> >[EMAIL PROTECTED]
> >
> >-- 
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >-- 
> >Author: Rusnak, George A.
> >  INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling 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: Jon Walthour
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling 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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: moving tables to a different tablespace

2001-07-26 Thread Traci Rebman 

Al,

Try doing an import with show=y, and check the tablespace in the DDL.  You may need to 
manually edit the DDL and change the tablespace from SYSTEM to OUTLN_TS.  I have found 
that  a fromuser/touser will not force an override of the tablespace in the export 
dump file.

Traci L. Rebman
Database Administrator
D&E Communications, Inc.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Traci Rebman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: moving tables to a different tablespace

2001-07-26 Thread Hand, Michael T 

Al,
In order to assure the tables end up in a tablespace other than the one from
which they originated, you'll have to create empty tables in the outln_ts
tablespace prior to the import (between step 4 & 5).  Easiest way is to to a
import w/ indexfile=, then edit and run this file.

Mike Hand
Polaroid Corp

-Original Message-
Sent: Thursday, July 26, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L


Hi Group,
Please explain what I am doing wrong.
1)  exp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
3)  Created tablespace outln_ts on webprod
4)  Altered user outln default tablespace outln_ts
5)  imp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
6)  SQL> select table_name, tablespace_name
   from dba_tables 
   where owner = 'OUTLN';

  TABLE_NAME TABLESPACE_NAME
--
--
 OL$SYSTEM
 OL$HINTS   SYSTEM
 XX
OUTLN_TS

WHY are the tables being re-imported back into SYSTEM tablespace 

Oracle 8.1.7 on Sun Solaris 5.7

TIA

Al Rusnak
804-734-8453
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rusnak, George A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: moving tables to a different tablespace

2001-07-26 Thread Kevin Lange 

I am sure someone answered already ... but

The tablespace is associated with the table create statement in the import
file.  If you created the structures of the tables in the tablespace that
you wanted BEFORE you import the file and specify ignore errors then the
tables would be loaded into the correct tablespace.


If you had a tool such as Toad you could do it easier without having to
perform the import/export move.  There is an option on it to rebuild tables.
Just specify a  different table space name.

-Original Message-
Sent: Thursday, July 26, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L


Hi Group,
Please explain what I am doing wrong.
1)  exp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
3)  Created tablespace outln_ts on webprod
4)  Altered user outln default tablespace outln_ts
5)  imp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
6)  SQL> select table_name, tablespace_name
   from dba_tables 
   where owner = 'OUTLN';

  TABLE_NAME TABLESPACE_NAME
--
--
 OL$SYSTEM
 OL$HINTS   SYSTEM
 XX
OUTLN_TS

WHY are the tables being re-imported back into SYSTEM tablespace 

Oracle 8.1.7 on Sun Solaris 5.7

TIA

Al Rusnak
804-734-8453
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rusnak, George A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: moving tables to a different tablespace

2001-07-26 Thread Peter Gram 

Hi Rusnak

I will not comment on that the tales is OUTLN's, but since you are using 8.1.7
then you can use "alter table OL$ move tablespace x"

"Rusnak, George A." wrote:

> Hi Group,
> Please explain what I am doing wrong.
> 1)  exp outln/outln@webprod   file=exp_file
> tables = 'OL$' 'OL$HINTS'
> 2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
> 3)  Created tablespace outln_ts on webprod
> 4)  Altered user outln default tablespace outln_ts
> 5)  imp outln/outln@webprod   file=exp_file
> tables = 'OL$' 'OL$HINTS'
> 6)  SQL> select table_name, tablespace_name
>from dba_tables
>where owner = 'OUTLN';
>
>   TABLE_NAME TABLESPACE_NAME
> --
> --
>  OL$SYSTEM
>  OL$HINTS   SYSTEM
>  XX
> OUTLN_TS
>
> WHY are the tables being re-imported back into SYSTEM tablespace 
>
> Oracle 8.1.7 on Sun Solaris 5.7
>
> TIA
>
> Al Rusnak
> 804-734-8453
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rusnak, George A.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling 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).

--
Best regards

Peter Gram

Miracle A/S
http://MiracleAS.dk
Tel: +45 2527 7107


 smime.p7s

RE: moving tables to a different tablespace

2001-07-27 Thread Adrian Roe 

Have you looked at ALTER TABLE...MOVE... ?

Ade

-Original Message-
Sent: 26 July 2001 18:51
To: [EMAIL PROTECTED]


Hi Group,
Please explain what I am doing wrong.
1)  exp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
2)  Dropped the tables: 'OL$' and 'OL$HINTS' on webprod
3)  Created tablespace outln_ts on webprod
4)  Altered user outln default tablespace outln_ts
5)  imp outln/outln@webprod   file=exp_file
tables = 'OL$' 'OL$HINTS'
6)  SQL> select table_name, tablespace_name
   from dba_tables 
   where owner = 'OUTLN';

  TABLE_NAME TABLESPACE_NAME
--
--
 OL$SYSTEM
 OL$HINTS   SYSTEM
 XX
OUTLN_TS

WHY are the tables being re-imported back into SYSTEM tablespace 

Oracle 8.1.7 on Sun Solaris 5.7

TIA

Al Rusnak
804-734-8453
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rusnak, George A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).