Home » RDBMS Server » Server Utilities » importing error
importing error [message #218311] Wed, 07 February 2007 13:06 Go to next message
khosravi
Messages: 68
Registered: April 2006
Member
hello
please guide me
in my schema i have one cluster and three tables with this specification
---------------------------------------------------------------------
CREATE CLUSTER clus_branch_request(
sendingDate date,
requestNumber varchar2(32 char),
branchCode varchar2(50 char),
bankCode varchar2(50 char)
);
CREATE INDEX clus_branch_request_ind ON CLUSTER clus_branch_request;

CREATE TABLE printedCustomerRequest (
requestNumber VARCHAR2 (50 char) ,
branchRequestNumber VARCHAR2 (32 char) NOT NULL ,
branchCode VARCHAR2 (50 char) NOT NULL ,
bankCode VARCHAR2 (50 char) NOT NULL ,
sendingDate date DEFAULT SYSDATE NOT NULL ,
customerAccountNumber VARCHAR2 (50 char) NOT NULL ,
customerName VARCHAR2 (200 char) ,
checkbookCode VARCHAR2 (50 char) NOT NULL ,
sendingBranchCode VARCHAR2 (50 char) NOT NULL ,
sundry NUMBER(1,0) NOT NULL ,
deviceCode VARCHAR2 (50 char) NOT NULL ,
beginSerial VARCHAR2 (50 char) NOT NULL ,
endSerial VARCHAR2 (50 char) NOT NULL ,
seri VARCHAR2 (50 char) NOT NULL ,
seriChar VARCHAR2 (3) NOT NULL ,
cancellation NUMBER(1,0) DEFAULT 0 NOT NULL ,
cancellationReason VARCHAR2 (50 char) ,
issueDate date DEFAULT SYSDATE NOT NULL ,
tag VARCHAR2 (4 char) ,
user_name VARCHAR2 (100 char) DEFAULT USER NOT NULL,
CONSTRAINT printedCustomerRequest_pk PRIMARY KEY (
bankCode,beginSerial,endSerial,seri,seriChar) DEFERRABLE
) CLUSTER clus_branch_request(
sendingDate,
branchRequestNumber,
sendingBranchCode,
bankCode);



CREATE TABLE customerRequest (
requestNumber VARCHAR2 (32 char) ,
branchRequestNumber VARCHAR2 (32 char) NOT NULL ,
branchCode VARCHAR2 (50 char) NOT NULL ,
bankCode VARCHAR2 (50 char) NOT NULL ,
sendingDate date DEFAULT SYSDATE NOT NULL ,
customerAccountNumber VARCHAR2 (50 char) NOT NULL ,
customerName VARCHAR2 (200 char) ,
checkbookCode VARCHAR2 (50 char) NOT NULL ,
numberOfchekbook NUMBER(2,0) NOT NULL ,
sendingBranchCode VARCHAR2 (50 char) NOT NULL ,
numberOfIssued NUMBER(2,0) DEFAULT 0 NOT NULL ,
sundry NUMBER(1,0) DEFAULT 0 NOT NULL ,
file_reading_date date DEFAULT SYSDATE ,
user_name VARCHAR2 (100 char) DEFAULT USER NOT NULL ,
TMP NUMBER(2,0) DEFAULT 0 NOT NULL ,
CONSTRAINT customerRequest_pk PRIMARY KEY
(branchRequestNumber,
branchCode,bankCode,
sendingDate,customerAccountNumber,
checkbookCode,sendingBranchCode) DEFERRABLE
)CLUSTER clus_branch_request(
sendingDate,
branchRequestNumber,
sendingBranchCode,
bankCode);



CREATE TABLE branchRequest (
sendingDate date DEFAULT SYSDATE NOT NULL ,
requestNumber VARCHAR2 (32 char) NOT NULL ,
documentNumber VARCHAR2 (50 char) ,
branchCode VARCHAR2 (50 char) NOT NULL ,
bankCode VARCHAR2 (50 char) NOT NULL ,
user_name VARCHAR2 (100 char) DEFAULT USER NOT NULL ,
TMP NUMBER(2,0) DEFAULT 0 NOT NULL ,
CONSTRAINT branchRequest_pk PRIMARY KEY
(sendingDate,requestNumber,branchCode,bankCode) DEFERRABLE
)CLUSTER clus_branch_request(
sendingDate,
requestNumber,
branchCode,
bankCode);
-----------------------------------------------------------------------------------------------
i export the schema by this command

exp system/ali120 file=c:\cbdmanager owner=cbdmanager

but when i import that export file by this command

imp system/ali120 file=c:\cbdmanager fromuser=cbdmanager touser=ali

i receive this erros

IMP-00017: following statement failed with ORACLE error 1447:
" ALTER TABLE "BRANCHREQUEST" MODIFY ("SENDINGDATE" DEFAULT SYSDATE )"
IMP-00003: ORACLE error 1447 encountered
ORA-01447: ALTER TABLE does not operate on clustered columns

IMP-00017: following statement failed with ORACLE error 1447:
" ALTER TABLE "CUSTOMERREQUEST" MODIFY ("SENDINGDATE" DEFAULT SYSDATE )"
IMP-00003: ORACLE error 1447 encountered
ORA-01447: ALTER TABLE does not operate on clustered columns

IMP-00017: following statement failed with ORACLE error 1447:
" ALTER TABLE "PRINTEDCUSTOMERREQUEST" MODIFY ("SENDINGDATE" DEFAULT SYSDATE"
" )"
IMP-00003: ORACLE error 1447 encountered
ORA-01447: ALTER TABLE does not operate on clustered columns

and that three tables don't import

[Updated on: Wed, 07 February 2007 13:08]

Report message to a moderator

Re: importing error [message #218314 is a reply to message #218311] Wed, 07 February 2007 13:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Known bug. Check Metalink.
If my memory does not fail, it has something to do with DEFAULT clause in create table.
Re: importing error [message #218774 is a reply to message #218314] Sat, 10 February 2007 00:36 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
thanks
you are right , i deleted default the problem resolve ,but why?
Re: importing error [message #218785 is a reply to message #218774] Sat, 10 February 2007 04:02 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>why?
Because it is bug Smile
Bug 973501. Please check the associated metalink note for the recomended fix.
Previous Topic: Querying flat files
Next Topic: two questions answer please
Goto Forum:
  


Current Time: Mon Dec 05 08:42:31 CST 2016

Total time taken to generate the page: 0.22071 seconds