OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » importing error

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

importing error [message #218311]

Wed, 07 February 2007 13:06

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