OraFAQ Forum: Server Utilities » Import tables order

Home » RDBMS Server » Server Utilities » Import tables order

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import tables order [message #72856]

Wed, 19 November 2003 04:56

Ravi
Messages: 251
Registered: June 1998

Senior Member

I am trying to import a list of tables, which I have specified in a parameter file with the tables = {...} option.
These tables have some references between them. So I have ordered these according to their dependencies.
But import is taking this list of tables and doing the import alphabetically, irrespective of the order in the tables parameter.
Is there any way to get it to import the tables in the order required?
I'm using 8i.

Thanks!

Report message to a moderator

Re: Import tables order [message #72858 is a reply to message #72856]

Wed, 19 November 2003 05:35

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

can you reproduce the case and post the session?
i tried . it works for me..

----------------------------------------------------------------------

i speficy the order...and it is exported in the same order...

----------------------------------------------------------------------

bash-2.03$ exp dbadmin/passCode  tables=(salgrade,emp,bonus,dept);

Export: Release 9.2.0.1.0 - Production on Wed Nov 19 07:33:31 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                       SALGRADE          5 rows exported
. . exporting table                            EMP          0 rows exported
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
Export terminated successfully without warnings.

----------------------------------------------------------------------

doing the import using ignore=y becuase the object already exist and i didnt drop them
the import is in the same order.

----------------------------------------------------------------------

bash-2.03$ imp dbadmin/passCode fromuser=dbadmin touser=dbadmin ignore=y

Import: Release 9.2.0.1.0 - Production on Wed Nov 19 07:37:03 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table                     "SALGRADE"          5 rows imported
. . importing table                          "EMP"          0 rows imported
. . importing table                        "BONUS"          0 rows imported
. . importing table                         "DEPT"          4 rows imported
Import terminated successfully without warnings.

Report message to a moderator

Re: Import tables order [message #72859 is a reply to message #72858]

Wed, 19 November 2003 06:36

Ravi
Messages: 251
Registered: June 1998

Senior Member

The import parameters specified are ---------
imp USER/PASSWORD@CONNECT INDEXES=N GRANTS=N ANALYZE=N IGNORE=Y ROWS=Y FILE="H:testDB3210400-18-11-2003.dmp" PARFILE="F:TEMPTables1.txt" LOG="F:Temptest.log"

Tables1.txt has
TABLES = (
SIGNPTV15,
POINT15SG,
ARYSPV15,
ARYSP15SG,
SIGNLINKSETTPV15,
SIGNLINKSETTP15SG,
SIGNLINKTPV15,
SIGNLINKTP15SG,
SIGNDATALINKTPV15,
SIGNDATALINKTP15SG,
SIGNROUTESETNEPARTV15 ,
SIGNROUTESETNEPART15SG ,
SIGNROUTENEPARTV15,
SIGNROUTENEPART15SG,
COMBINEDSIGNLINKSETTPV15,
COMBINEDSIGNLINKSETTP15SG,
STPSCREENINGTABLEV15,
STPSCREENINGTABLE15SG,
STPSCREENINGTABLELINEV15,
STPSCREENINGTABLELINE15SG
....

The session details are :----------------------
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production

Export file created by EXPORT:V08.01.07 via direct path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing SS7USER's objects into SS7USER
. . importing table "ALL30MINSIGNALLINGLINKDURA15SG" 0 rows imported
. . importing table "ALL30MINSIGNALLINGLINKDURASON4" 0 rows imported
. . importing table "ALL30MINSIGNALLINGLINKDURAV15" 0 rows imported
. . importing table "ALLSIGNALLINGLINKUTILISATI15SG" 0 rows imported
. . importing table "ALLSIGNALLINGLINKUTILISATISON4" 0 rows imported
. . importing table "ALLSIGNALLINGLINKUTILISATIV15" 0 rows imported
. . importing table "ALLSIGNALLINGPOINTUTILISAT15SG" 0 rows imported
. . importing table "ALLSIGNALLINGPOINTUTILISATSON4" 0 rows imported
. . importing table "ALLSIGNALLINGPOINTUTILISATV15" 0 rows imported
. . importing table "BACKUPACCESSPOINTSON4" 0 rows imported
. . importing table "BACKUPLINKAGESON4" 0 rows imported
. . importing table "CDPASSNSPCANALYSISSON4" 0 rows imported
. . importing table "CGACONVREL15SG" 0 rows imported
. . importing table "CGACONVRELSON4" 4 rows imported
. . importing table "CGACONVRELV15" 0 rows imported
. . importing table "CGPAGTANALYSISSON4" 0 rows imported
. . importing table "CGPASSNSPCRIANALYSISSON4" 0 rows imported
. . importing table "COMBINEDSIGNLINKSETTP15SG" 0 rows imported
. . importing table "COMBINEDSIGNLINKSETTPSON4" 14 rows imported
. . importing table "COMBINEDSIGNLINKSETTPV15" 0 rows imported
. . importing table "CONCERNEDAREA15SG" 0 rows imported
. . importing table "CONCERNEDAREASON4" 3 rows imported
. . importing table "CONCERNEDAREAV15" 0 rows imported
. . importing table "DEFAULTPROFILETABLE15SG" 0 rows imported
. . importing table "DEFAULTPROFILETABLESON4" 1 rows imported
. . importing table "DEFAULTPROFILETABLEV15" 1 rows imported
. . importing table "DPCGROUP15SG" 4 rows imported
. . importing table "DPCGROUPSON4" 34 rows imported

Report message to a moderator

Re: Import tables order [message #72860 is a reply to message #72859]

Wed, 19 November 2003 07:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did u export the tables in your order?
if u do a whole user export, u no need to worry about the references.
It will be taken care automatically

Report message to a moderator

Re: Import tables order [message #72863 is a reply to message #72860]

Wed, 19 November 2003 20:28

Ravi
Messages: 251
Registered: June 1998

Senior Member

The table list is the same one being used for export and import.

I want to export only some tables and import them, as the others have changed.

Report message to a moderator

Previous Topic:	Modify data while loading with SQL*Loader
Next Topic:	SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 12:53:54 CDT 2024