Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: exporting tablespaces
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
![]() |
![]() |