Re: Full Ex/Im-port to New Instance, NT

Oracle Corporation Support
Microsoft Servers and Utilities Technical Forum

Displayed below are the messages of the selected thread.

From: sanjay singuri
Subject: export utility
Posted on: 23-Feb-1998 13:07:57

RDBMS Version: 7.3.2.3
Error Number (if applicable): 1
Operating System and Version: 10.22
Tool (i.e. SQL*Loader, Import, etc.): imp Tool Version: imp 7.3.2.2

Scenario:
User A default tablespace ABC
User B default tablespace XYZ
Problem:
User A export taken and
when trying to import into newly created User B the import is working fine,
Objects are created in User B that's fine But data is being written on to User A's default tablespace ABC, For some reason it is not writing into the importing user's default tablespace.
Early Solution required
Thanks in Advance
Sanjay

From: Bob Sheng
Subject: Re : export utility
Posted on: 23-Feb-1998 14:52:16
What happened if you give user B
no quoto on User A's default tablespace ABC.

• Bob_at_usps

From: David Hunter
Subject: Re : export utility
Posted on: 24-Feb-1998 15:10:43
Hi,

Please list the exact command and parameters you are using on the import.

Also please create a log of the import so I can see the commands used to actually shift from the importing users schema to the exporting users schema.

Dave Hunter
Oracle Support

From: sanjay singuri
Subject: Re : Re : export utility
Posted on: 02-Mar-1998 12:35:51
I am doing an interactive export and import. The parameters I am passing are all default values except for the buffer which is 1024000.
This is a user level export.
I have also tried with command line as follows: exp usr1/usr1 file=abc.dmp log=l.log
Then
When I am trying to import this abc.dmp into usr2(new user with separate tablespace) either interractively or command line , It is writing into the previous users usr1's
default tablespace.
This is the scenario,and parameters are as above. The command line import I tried is as below imp usr2/usr2 file=abc.dmp

From: David Hunter
Subject: Re : Re : Re : export utility
Posted on: 04-Mar-1998 10:17:07
Hi,

Try import parameters FULL=Y or FROMUSER=USER1 TOUSER=USER2. Dave Hunter
Oracle Support

From: sanjay singuri
Subject: Re : Re : Re : Re : export utility Posted on: 04-Mar-1998 11:06:24
Hi David,
I've tried using FROMUSER, TOUSER parameters aswell. Let me try FULL=Y
Thanks
Sanjay

From: sanjay singuri
Subject: Re : Re : Re : Re : Re : export utility Posted on: 23-Mar-1998 07:22:37
Hi
I'm sorry I have tried using FROMUSER & TOUSER but the results are not possible.I wonder why is this happening. Thanks
Sanjay

From: David Hunter
Subject: Re : Re : Re : Re : Re : Re : export utility Posted on: 23-Mar-1998 13:40:08
Please do an import using the SHOW command and write to a logfile so I can see the commands import is doing. You can either post the file or email it to me.

Thanks,

Dave Hunter
Oracle Support

From: Michael McCracken
Subject: Re : Re : Re : Re : Re : Re : Re : export utility Posted on: 27-Mar-1998 10:44:00
Doesn't Import always use the exported table's tablespace? Since the TOUSER and FROMUSER only change the schema, this would not effect the tablespace name. I don't know of anyway to change the tablespace name during the import.

So, if user A has tables defined in tablespace A, even if you import to user B, the import will still try to create the tables in user A's tablespaces.

From: Terrance Webster
Subject: Re : Re : Re : Re : Re : Re : Re : Re : export utility Posted on: 07-Apr-1998 06:04:33
This is correct.

Either pre-define the table where you want it or make sure that the tablespace where its coming from doesn't exist.

If the tablespace is not found IMPORT will use the default tablespace for the TOUSER.
(AFAIK!!!) Cheers,

Terry

From: Ravi Madhavarao
Subject: Re : Re : Re : Re : Re : Re : Re : Re : Re : export utility Posted on: 08-Apr-1998 03:06:14
You can import to the user default tablespace.(I have tested)

Example: user A is exported default tablespace is X, import to user B default tablespace is Y.

follow the below .

create user B ...... default tablespace Y; grant connect,resource to B;

Note: when you grant resource to the user it will also grant unlimited tablespace. So in this case you have to revoke this priv.

revoke unlimited tablespace from B;

alter user B quota 10M on Y;

Now you import,
IMP xxx/xxx fromuser=a touser=b log=bbb

Now you can see the result:

connect B/B

select segment_name, tablespace_name from user_segments;

Thanks
Madhavarao Ravi (DBA)
Deutsche Bank - Singapore.

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*3U)'.D%%154-"E1)5$Q%.E-E;FEO<B!/<F%C M;&4_at_1$)!#0I414P[2$]-13M63TE#13HK-#0H,"DQ.#$@-#8P-# T,@T*5$5, M.T-%3$P[5D])0T4Z*S0T-#$Q.3 V-S<V#0I!1%([2$]-13M%3D-/1$E.1SU1 M54]4140M4%))3E1!0DQ%.CL[1FQA=" Y/3!$/3!!,3D_at_4V]U=&AL86YD)W,@ M1W)O=F4],$0],$$[0FEC:VQE>3M+96YT.T)2,2 R1$$[16YG;&%N9 T*3$%" M14P[2$]-13M%3D-/1$E.1SU154]4140M4%))3E1!0DQ%.D9L870@.3TP1#TP M03$Y(%-O=71H;&%N9"=S($=R;W9E/3!$/3!!/3!$/3!!0FEC:VQE>2P_at_2V5N M="!"4C$@,D1!/3!$/3!!16YG;&$]#0IN9 T*55),.FAT=' Z+R]W=W<N:VAO M9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E523#IH='1P.B\O=W=W+F%E974N;W)G M+G5K#0I%34%)3#M04D5&.TE.5$523D54.GEA<W-I<D!K:&]G86QY+F9R965S M97)V92YC;RYU:PT*4D56.C$Y.3_at_Q,#$R5# W,C S-UH-"D5.1#I60T%21 T* `
end Received on Mon Oct 12 1998 - 02:20:37 CDT