RE: Ghost Data

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Tue, 30 Jun 2009 16:35:36 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E1128D50834_at_ONEWS06.oneneck.corp>

It was application data - sales orders, customers, etc. Here is a script of the exact steps I executed, including a small sample of the unexpected data I found in the datafile:

SQL_test01>CREATE TABLESPACE "BATEST" DATAFILE '/testdb/develop/test01/oradat/batest.dbf' SIZE 128K AUTOEXTEND ON NEXT 128K MAXSIZE 1M LOGGING EXTENT MANAGEMENT LOCAL;

Tablespace created.

SQL_test01>create table batab(col1 number, col2 char(10), col3 date) tablespace batest;

Table created.

SQL_test01>host
hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf Z[\]
TEST01
BATEST hp50c.test01 /testdb/develop/test01/oradat ->exit

SQL_test01>insert into batab values (1,'BA Row 1',sysdate);

1 row created.

SQL_test01>host

hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf Z[\]
TEST01
BATEST hp50c.test01 /testdb/develop/test01/oradat ->exit

SQL_test01>commit;

Commit complete.

SQL_test01>host

hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf Z[\]
TEST01
BATEST hp50c.test01 /testdb/develop/test01/oradat ->exit

SQL_test01>alter system checkpoint;

System altered.

SQL_test01>exit

hp50c.test01 /testdb/develop/test01/oradat ->strings batest.dbf Z[\]
TEST01
BATEST
        14159.003 (<-- this data and all below except the last line were never entered into any table in this tablespace!) LABCORP337
INSTALLATION
Installation Services
DEFAULT
SERVICES
DFLT
BKIMBAL2 . . .

BA Row 1 (<-- here is the only data I actually entered)

From: Julio Aguilar-Chang [mailto:jachang_at_lanl.gov]

Please explain "it had a bunch of data from other database tables in it". Is this other data actual "application" data, not just data dictionary data?

---

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 30 2009 - 18:35:36 CDT