Re: what is the utility of the tablespace (newbie)

dominant wrote:

>In my case, i transfered a database from 7.3.3.0.0 ora server to
>9.2.0.1.0 but the tablespaces were not transfered.
>
>
>
>If i let the database grown with the default tablespace of ora
>server 9.2.0.1.0 (SYSTEM), can any error rise during data storing
>(damaging my data)
>
>
>--
>Posted via http://dbforums.com
>
>

Depends. You've hardly given us enough information to help you.

My generic advice would be to NEVER use Oracle's datafiles and tablespaces for an
application. These are resources that should be created with an understanding of issues
ranging from performance to backup and recovery.

Why don't you post some information on what you are doing and let others take a look.
Worse case though, you've just made it slower and uglier. Nothing you did short of something
really stupid like using the SYSTEM tablespace could be deadly.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)