Re: Can you perform online/offline backups with logical objects?

From: Frederic Houbie <fh_at_ionicsoft.com_nospamplz>
Date: Tue, 17 Jun 2003 09:37:24 +0200
Message-ID: <3EEEC534.6000409@ionicsoft.com_nospamplz>

Hi,

I'm also trying to backup a Oracle database with Object definitions. When I do an export, no problem, but when I try to import it I have trouble. I tried dropping all the tables and type definition, but when I import, I get errors

IMP-00017: following statement failed with ORACLE error 931:

  "CREATE TABLE "REGISTRYENTRIES" OF "REGISTRYENTRY" OID 'BF5C55544AA4B49AE030"
  "000A16002F9D' OIDINDEX (PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL "
  "32768 NEXT 24576 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FRE"
  "ELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM")  PCTFREE 10 PCTUSE"
  "D 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 204800 NEXT 98304 MINEXTENTS 1"
  " MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DE"
  "FAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS XMLTYPE TREAT(SYS_NC_ROWINFO$"
  " AS "WRS"."EXTRINSICOBJECT")."XMLCONTENT" STORE AS CLOB  (TABLESPACE "SYSTE"
  "M" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIAL "
  "16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FRE"
  "ELIST GROUPS 1 BUFFER_POOL DEFAULT))"

IMP-00003: ORACLE error 931 encountered
ORA-00931: missing identifier
Any Idea ?

Fred

Richard Foote wrote:
> "Peter" <peter_at_nomorenewsspammin.ca> wrote in message
> news:s3dgevol107auc99oh1pgp042qlg18hfvl_at_4ax.com...
>

>>Can you perform both online/offline backups with logical objects?
>>
>>Thanks
>>

>
>
> Hi Peter,
>
> If I understand your question, then the Export utility is your answer
> ("online" backup only).
>
> Check out the Utilities manual for the nitty gritty
>
> Cheers
>
> Richard
>
>
Received on Tue Jun 17 2003 - 02:37:24 CDT