delete with standalone deploy

I am using standalone dd to deploy my contents in oracle.
I want to know how to delete the records using dd when dcr gets deleted.

any help??

Find more posts tagged with

Comments

Migrateduser

for deleting using standalone you have to use filelist deployments

avdhut

yes i'm using filelist deployment.
it is working fine for pushing the contents in. but when the file is deleted it detects the NotPresent state but then it still tries to update the contents in database instead of doing the delete..
here is the log...
---------------
SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWOV_IDMAPS'
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 0
# view mappings: 0
# constraint mappings: 0
SELECT * FROM USER_TABLES WHERE TABLE_NAME='CRT_ENGINE'
Table <CRT_ENGINE> exists.
Running deployment [submitlist]
extraction type=full
tuple mode=narrow
area=/EBU/main/Marketing/circuit.com/Ver2-0/Content/WORKAREA/Content_wa
filelist=[/var/tmp/aaaNsaqrZ]
/EBU/main/Marketing/circuit.com/Ver2-0/Content/WORKAREA/Content_wa/templatedata/circuit_toplevelanchors/engine/data/test
Generate DirectoryContents start:Mon Oct 14 09:18:14 EST 2002
Generate DirectoryContents end :Mon Oct 14 09:18:14 EST 2002
Generate TDCRTupleProducer start:Mon Oct 14 09:18:14 EST 2002
Generate TDCRTupleProducer end :Mon Oct 14 09:18:14 EST 2002
Path not found -- interpret as 'NotPresent'
TUPLE={state=NotPresent, path=templatedata/circuit_toplevelanchors/engine/data/test}
.....
TTableSchemaHelper object for [CRT_ENGINE] found in cache.
WHERE clause parameter 1: templatedata/circuit_toplevelanchors/engine/data/test
Column: DCR_Path, field: path, Index: 1,Converting 'templatedata/circuit_toplevelanchors/engine/data/test' to VARCHAR
Using PreparedStatement for Update...
------------------------

avdhut

Is there any documentation available regarding this issue??

would appreciate any example if anybody has already done this...

Migrateduser

are you using <dbschema> or without it? If you are using <dbschema> check if "state-field" has been set to "state" in <database> section. If you aren't using <dbschema> check if state-field is set in the <update> tag.

avdhut

oh wow...it worked.

thanks a lot Smiley Happy