Re: exporting tablespaces

If you ran a full export everything is exported including those tablespaces. The dump file will contain create tablespace statements including the name of the original datafile. If your file structure is not the same, you'll need to precreate them. Running with ignore=y prevents imp from aborting on error, so you'll need to use that option and import with imp <username/password> file= full=y ignore=y commit=y buffer=8192000 etc.

Hth.

Sybrand Bakker, Oracle DBA

Steve . <syarbrou_at_nospam.enteract.com> schreef in berichtnieuws t43ojscj6ie4pi1so4jl54diocusntnldf_at_4ax.com...
> I ran exp on an entire database, hoping it would create a dump of
> "everything" for that database instance. I have two tablespaces:
> cbr_indexes and cbs_hrpls. Are those exported automatically as well
> into the dump file? Didn't look like it.
>
> Also, if they are, and I import them into a new database instance, do
> I need to create the tablespaces first so the dump file knows where to
> put them? If not, won't it use the paths to the original tablespaces
> to export the data into, rather than a new copy of the tablespace in a
> new location for the second database instance? Thanks.
>
> Steve
>
> Newsgroup replies preferred. Remove nospam when replying thru email.
Received on Mon Jun 05 2000 - 00:00:00 CDT