RE: export as user A in tablespace B, import as user C in

IMP-option :

INDEXFILE = [filename]

This will create an SQL with all create-statements for tables (Though they are REMARKED and thus not executed) AND all indexes !!!

> -----Original Message-----
> From: Dries Verachtert [SMTP:dries_at_ulyssis.org]
> Sent: Thursday, November 02, 2000 12:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: export as user A in tablespace B, import as user C in
>
>
> Hello,
>
> Thanks a lot for the help! But euh.. i don't know how i have to create an
> indexfile or what it is. Ok, it would be much better if i would search the
> docs for it myself.. but it's all quite urgent here: the developpers can't
> work further. So, can you please tell me which program i have to use to
> make
> an indexfile, or a link to some documentation?
>
> Thanks in advance,
> Dries Verachtert
>
>
> On Thu, 2 Nov 2000 ramakrishna.gv_at_db.com wrote:
>
> > Date: Thu, 02 Nov 2000 01:51:12 -0800
> > From: ramakrishna.gv_at_db.com
> > Reply-To: ORACLE-L_at_fatcity.com
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Re: export as user A in tablespace B, import as user C in
> >
> > Hi
> > In your import statement give option ignore=y.
> > u can ignore those warnings as the objects are already exsting and it
> is trying to create the object again.
> > to avoid the importing into wine tablespace,
> > create indexfile with rows=no parameter
> > change the tablespace names and other things which ever
> u want in indexfile.
> > run the indexfile.
> > import only the data with rows=yes.
> >
> >
> > Thanks & Regards
> > ----------------------------
> > Ram
> > Tel:4236953
> >
> >
> > ---------------------------------------- Message History
> ----------------------------------------
> >
> >
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > To: ORACLE-L_at_fatcity.com
> > cc:
> >
> >
> >
> >
> > Hello,
> >
> > We got 2 databaseservers here: 1 online server and 1 development server.
> We
> > use oracle8i 8.1.6 on linux and the site runs on php4 on apache.
> >
> > At the online server, the whole site uses the login 'wine'. At the
> > development server, we have a user named 'winemirror'. I need to export
> all
> > tables, constraints and rows (just everything owned by the user) at the
> > online server and import this data back in the schema of 'winemirror' at
> the
> > development server, because we need the data to test some new fancy
> > statistics stuff. We can't use another 'wine' user instead of
> 'winemirror'
> > because that's the backupdatabase in case the online fails.
> >
> > Can anyone explain me how those imp and exp utilities work? If the
> > usernames are the same, everything works ok:
> > onlineserver# exp wine/<pass> FILE=wine.dmp
> > develserver# imp wine/<pass> FILE=wine.dmp
> > (+ some exports like NLS_LANG..)
> >
> > When the username is different, i think i should use:
> > develserver# imp winemirror/<pass> FILE=wine.dmp FROMUSER=wine
> TOUSER=winemirror
> >
> > But this doesn't work.. i get a lot of warnings about the tables already
> > existing.
> >
> > a part of the output is:
> >
> > . . importing table "TBLACTIONS" 0 rows
> imported
> > IMP-00015: following statement failed because the object already exists:
> > "ALTER TABLE "TBLACTIONS" ADD CONSTRAINT "TBLACTIONS" PRIMARY KEY
> ("ILOGINI"
> > "D","ISEQNBR") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIA"
> > "L 54272000 NEXT 2048000 MINEXTENTS 2 MAXEXTENTS 50 PCTINCREASE 99
> FREELISTS"
> > " 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WINE4" ENABLE "
> > . . importing table "TBLACTIONTYPES" 1 rows
> imported
> > IMP-00015: following statement failed because the object already exists:
> > "ALTER TABLE "TBLACTIONTYPES" ADD CONSTRAINT "PK_TBLACTIONTYPES"
> PRIMARY KE"
> > "Y ("IID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
> STORAGE(INITIAL 57"
> > "344 NEXT 40960 MINEXTENTS 2 MAXEXTENTS 50 PCTINCREASE 50 FREELISTS 1
> FREELI"
> > "ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WINE4" ENABLE "
> > . . importing table "TBLADDRESSES" 339 rows
> imported
> > IMP-00015: following statement failed because the object already exists:
> > "ALTER TABLE "TBLADDRESSES" ADD CONSTRAINT "PK_TBLADDRESSES" PRIMARY
> KEY (""
> > "IID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL
> 57344 "
> > "NEXT 40960 MINEXTENTS 2 MAXEXTENTS 50 PCTINCREASE 50 FREELISTS 1
> FREELIST G"
> > "ROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WINE4" ENABLE "
> >
> > It always tries to use tablespace wine4. That's the name of the
> tablespace
> > of the user at the online server. At the develserver, the user
> winemirror
> > has it's own tablespace winemirror.
> >
> > Has anyone any ideas what i'm doing wrong? Just let me know if you need
> any
> > further information. All help is welcome.
> >
> > If you want to know why all the loginnames contain 'wine': it's a
> > winecommunity/wineshop site at http://www.underthecork.com
> >
> > Thanks in advance,
> > Dries Verachtert
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Dries Verachtert
> > INET: dries_at_ulyssis.org
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
>
> --
> ----
> Dries Verachtert, Skotty_at_IRC, dries_at_ulyssis.org
> "You're one of those condescending Unix computer users!"
> "Here's a nickel, kid. Get yourself a better computer" - Dilbert.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dries Verachtert
> INET: dries_at_ulyssis.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Thu Nov 02 2000 - 05:46:27 CST