Re: exporting tablespaces

Objects are created in a tablespace, where that tablespace is doesn't matter.
So yes if you precreate that tablespace prior to the import with a changed filename, as it is using that tablespace already: there should be no problem (or the tablespace creation failed).

Likewise, you can use the .log but you need to edit. The 'snapshot' you included will not run without further editing. The " need to be removed, and no identifier should be on two different lines. Steve Hauser has an utility to do that, he posted the location a few days ago, so you might look up www.deja.com to find it.

Hth,

Sybrand Bakker, Oracle DBA

Steve . <syarbrou_at_nospam.enteract.com> schreef in berichtnieuws l1eojscu93947o1psoeqaqffoghplr0gid_at_4ax.com...
> Thanks, so for example below, just to verify, I have the following
> create tablespace entry in the dump file for database instance k51:
>
> ---- snip ----
>
> "CREATE TABLESPACE "CBR_INDEXES" DATAFILE
> '/home/oracle8i/u01/app/oracle/pr"
> "oduct/8.1.5/dbs/cbr_indexes.dbf' SIZE 52428800 DEFAULT
> STORAGE(INITI"
> "AL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50)
> ONLINE PERM"
> "ANENT "
>
> ---- snip ----
>
> You see the path
> /home/oracle8i/u01/app/oracle/product/8.1.5/dbs/cbr_indexes.dbf in the
> file. That is where cbr_indexes resides for k51. So by default it
> will write it to that location. If I want to exp this file to k52, do
> I create a tablespace under the second database instance(k52), and
> place it in /home/oracle8i/u01/app/oracle/oradata/k52/cbr_indexes.dbf,
> will it automatically populate that one? Thanks.
>
> And one other, the large log I exported of the contents of the dump
> file, can that be run in SQLPlus?
>
> Steve
>
>
> On Mon, 5 Jun 2000 22:53:24 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >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 Tue Jun 06 2000 - 00:00:00 CDT