full exp do exp all tablespaces

来源: nymd 于 2006-08-01 12:55:10 [] [旧帖] [给我悄悄话] 阅读数 : (333 bytes)
回答: 回复：9i destination and dmp seems to be 8i 由 真源湛寂 于 2006-08-01 12:33:33

full exp do exp all tablespaces.

when you imp, all tablespaces will be re-create at new databse. if the tablespaces were not exist, it will be a big problem because you have no right to create data file.

as user to imp from a full exp dmp file, use imp user=yourname will provent a lot problems which you can solve.

所有跟帖： 

• 假如是这种情况， 您必须先 Create ALL NEW tablespace first. -真源湛寂- ♂ 给 真源湛寂 发送悄悄话 真源湛寂 的博客首页 (9 bytes) () 08/01/2006 postreply 13:02:22

• I only import to a schema, not the whole DB. Maybe there is no t -newfaith- ♂ 给 newfaith 发送悄悄话 (0 bytes) () 08/01/2006 postreply 13:10:39

• tablespace issue? -newfaith- ♂ 给 newfaith 发送悄悄话 (0 bytes) () 08/01/2006 postreply 13:11:59

• if this schema already in the database? -真源湛寂- ♂ 给 真源湛寂 发送悄悄话 真源湛寂 的博客首页 (44 bytes) () 08/01/2006 postreply 13:13:21

• no. I am creating a new scheam -newfaith- ♂ 给 newfaith 发送悄悄话 (0 bytes) () 08/01/2006 postreply 13:31:13

• 对不起。 我不是问 SCHEMA， 我是问 TABLESPACE -真源湛寂- ♂ 给 真源湛寂 发送悄悄话 真源湛寂 的博客首页 (41 bytes) () 08/01/2006 postreply 14:01:57

请您先登陆，再发跟帖！