Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: exporting tablespaces

Re: exporting tablespaces

From: Steve . <syarbrou_at_nospam.enteract.com>
Date: 2000/06/05
Message-ID: <l1eojscu93947o1psoeqaqffoghplr0gid@4ax.com>#1/1

Thanks, so for example below, just to verify, I have the following create tablespace entry in the dump file for database instance k51:

"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 "

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 Mon Jun 05 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US