EBS Customizations (MOSC)

MOSC Banner

EBS 12.2 xdfgen.pl loading custom table into wrong tablespace

Hello. I believe I've correctly followed the guidelines for creating a custom table in a 12.2 DEV environment:

• Use CREATE TABLE ... TABLESPACE TS1

• exec ad_zd_table.upgrade

• Add data to the table

• Use xdfgen.pl to create a .ldt file

I then move the .ldt file to our QA environment and run:

• xdfcmp.pl (this requires the APPS username/password)

The table does get created in QA BUT the table goes to the default tablespace for APPS--NOT the TS1 use during the CREATE TABLE process. I've verified that the TS1 tablespace does exist in QA. Further I've looked at the .ldt file and the tag <TS_NAME> does have the value TS1.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center