Re: moving data from 8.0.5 user_data tablespace to 8.1.7 users tablespace

On 22 Mar 2002 10:43:34 -0800, jriker1_at_yahoo.com (John) wrote:

>I am moving data from an existing 8.0.5 server which uses it's own
>tablespace names different from the default ones in 8.1.7. I however
>do not want a "custom" structure, but want to use oracle's default
>naming convensions for users and temp files, etc. Is there a way to
>export the 8.0.5 data, and then import it into 8.1.7 without requiring
>to have the 8.0.5 tablespace files on the system? So if I have data
>in user_data, and want it to go into users on the import, is that
>possible? Thanks.
>
>JR

Sure, provided
the 'receiving' user doesn't have unlimited tablespace privilege the 'receiving' user has quota (alter user ...quota unlimited on users)
the receiving users default tablespace is users

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 22 2002 - 12:52:26 CST