Home » RDBMS Server » Server Utilities » Problem: Import Bulk database in 8i to 10g
|
|
|
|
|
Re: Problem: Import Bulk database in 8i to 10g [message #300049 is a reply to message #300023] |
Thu, 14 February 2008 01:53 |
hb_venkatesh
Messages: 9 Registered: October 2007 Location: india
|
Junior Member |
|
|
Ok Michel,
This is the report of my log file
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
"ALTER SCHEMA = "SYSTEM""
"CREATE TABLESPACE "RBS" DATAFILE 'D:\ORACLE\ORADATA\ORA\RBS01.DBF' SIZE 50"
"3316480 AUTOEXTEND ON NEXT 5242880 MAXSIZE 4095M DEFAULT STORAGE(IN"
"ITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50) ONLIN"
"E PERMANENT ".................
.......................
"CREATE TABLE "INVOICE" ("DEPOT_CODE" NUMBER(2, 0), "INVOICE_NO" NUMBER(6, 0"
"), "INVOICE_DATE" DATE, "CUSTOMER_CODE" VARCHAR2(6), "CONSIGNEE_CODE" NUMBE"
"R(2, 0), "ORDER_NO" NUMBER(6, 0) NOT NULL ENABLE, "QUANTITY" NUMBER(8, 3) N"
"OT NULL ENABLE, "BASIC_AMOUNT" NUMBER(12, 2) NOT NULL ENABLE, "EXCISE_DUTY""
" NUMBER(11, 2), "SALES_TAX" NUMBER(11, 2), "SURCHARGE_ON_STAX" NUMBER(10, 2"
"), "FREIGHT_AMOUNT_FOR" NUMBER(11, 2), "INVOICE_AMOUNT" NUMBER(12, 2) NOT N"
"ULL ENABLE, "ROUNDING_PAISE" NUMBER(5, 2), "FREIGHT_AMOUNT" NUMBER(11, 2), "
""CLASSIFICATION" VARCHAR2(1), "EXWORKS_FOR_TAG" VARCHAR2(1), "SALE_TAX_CODE"
"" NUMBER(2, 0), "PRODUCT_CODE" NUMBER(2, 0), "CMA_RATE" NUMBER(5, 2), "RATE"
"" NUMBER(5, 2), "REALISATION_AMOUNT" NUMBER(12, 2), "POSTING_TO_FA" VARCHAR"
"2(1), "VOUCHER_NO" VARCHAR2(10), "VOUCHER_DATE" DATE, "CREATED_BY" VARCHAR2"
"(8), "CREATED_DATE" DATE, "STATE_CODE" NUMBER(2, 0), "DISTRICT_CODE" NUMBER"
"(2, 0), "TOWN_CODE" NUMBER(4, 0), "CESS_ON_ED" NUMBER(7, 2)) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 CACHE LOGGING STORAGE(INITIAL 59023360 NEX"
"T 29491200 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST "
"GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TBSCONSOLIDATION""
Up to this it can import after it goes idle..
venki
[Updated on: Thu, 14 February 2008 02:01] by Moderator Report message to a moderator
|
|
|
Re: Problem: Import Bulk database in 8i to 10g [message #300051 is a reply to message #300049] |
Thu, 14 February 2008 02:03 |
|
Michel Cadot
Messages: 68729 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Format does not mean put in bold. Read the link I posted.
Once again, are you sure it is idle? How did you check this?
Possible verifications: v$lock, v$session_wait, activate a trace on import session to see what it is doing.
Regards
Michel
|
|
|
Goto Forum:
Current Time: Sun Jan 12 01:41:13 CST 2025
|