Re: exporting TYPEs

8.1.7 on HP-UX
i
[1] Created a new schema PETER.

[2] Created table:

create table abc(a number, b date, c varchar2(30)); Table created.

[3] Created type:

CREATE TYPE person_t AS OBJECT
  (name CHAR(20),
   resume CLOB,
   picture BLOB);
/

Type created.

[4] Made export:

exp peter/peter file=pvr

Export: Release 8.1.7.3.0 - Production on Mon Jul 22 07:55:01 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production

With the Partitioning option

JServer Release 8.1.7.3.0 - Production

Export done in US7ASCII character set and WE8ISO8859P15 NCHAR character set

server uses WE8ISO8859P15 character set (possible charset conversion)

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user PETER

. exporting object type definitions for user PETER

About to export PETER's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export PETER's tables via Conventional Path ...

. . exporting table ABC 0 rows exported

. exporting synonyms

etc.etc.

Mind the TYPE's are in listed!

[5] But then:

strings pvr.dmp

EXPORT:V08.01.07 UPETER RUSERS 1024

Mon Jul 22 7:55:2 2002pvr.dmp

#G##

#G##

+00:00

8.1.6

BEGINTYPE "PERSON_T" "A656EFE089001BD6E03400306E0FBAE3" CREATE TYPE CREATE TYPE "PERSON_T" TIMESTAMP '2002-07-22:07:54:12' OID 'A656EFE089001BD6E034 00306E0FBAE3' AS OBJECT (name CHAR(20),

resume CLOB,

picture BLOB);

ENDTYPE TABLE "ABC" CREATE TABLE "ABC" ("A" NUMBER, "B" DATE, "C" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GR OUPS 1) TABLESPACE "GH_DATA" INSERT INTO "ABC" ("A", "B", "C") VALUES (:1, :2, :3) :

So it seems they (the TYPE's) are exported (as expected).

Kind regards,

Peter

"ralph" <discooctopus_at_yahoo.com> schreef in bericht news:U6J_8.10$fO4.18197_at_vicpull1.telstra.net...

> Hi,
>
> I am trying to export my entire schema, but it appears that it does not
> export the TYPE objects.
>
> I can not find any info on this in AskTom or MetaLink, and I was hoping

> someone else has encounteed this issue.
>
> Any ideas?
>
> * ORA 8.17
> * AIX
>
> Thanks
>
>