login
Search
I have table named 'liuxg_tab_01' in 10g.
This morning I exported this table using 'exp' and then tried to imp it into 8i, I failed.
After a while, I created a database link named 'ctf' in 8i which connected to 10g. I issued 'create table test as selct * from liuxg_tab_01@ctf',it returns 'ORA-01723'.
Then I extraced the DDL of 'liuxg_tab_01' from 10g with QUEST TAOD, it's:
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
CREATE TABLE LIUXG_TAB_01
(
OWNER VARCHAR2(30 BYTE),
OBJECT_NAME VARCHAR2(30 BYTE),
SUBOBJECT_NAME VARCHAR2(30 BYTE),
OBJECT_ID NUMBER,
DATA_OBJECT_ID NUMBER,
OBJECT_TYPE VARCHAR2(19 BYTE),
CREATED DATE,
LAST_DDL_TIME DATE,
TIMESTAMP VARCHAR2(19 BYTE),
STATUS VARCHAR2(7 BYTE),
TEMPORARY VARCHAR2(1 BYTE),
GENERATED VARCHAR2(1 BYTE),
SECONDARY VARCHAR2(1 BYTE)
)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
But I can not create a table using the upper DDL in 8i if I do not wipe off those "BYTES".
After creation of the table using the upper DDL without those 'BYTES', I sucessfully executed 'insert into LIUXG_TAB_01 select * from liuxg_tab_01@ctf'.
Anyone has a better method to move a table from ORACLE 10g to 8i?
Why you guys keep using Oracl
Why you guys keep using Oracle if its so complicated? Job Security?
I just have no choice.
My boss wants to use ORACLE. I prefer DB2.
I prefer Informix
Its much faster than Oracle or DB2. Its a 100 times easier and you'll never have so much pain migrating a table :)
Then why Oracle dominates the
Then why Oracle dominates the market?
In China, it seems DBAs are always talking about Oracle.
Oracle is King of databases
all other databases are toys. Real businesses want real tools, not toys; that is why serious players use Oracle.
There are expections to every rule, and every tool has a proper use, even (gasp!) sqlsever. Problems arise when people select a whimpy database to do a real job.
For those not using Oracle, don't worry, the rest of us will be here when your systems eventually fail.
The Biggest is not the Best
Microsoft has the largest share of the Operating System market. That doesn't make it the best. Oracle has managed to dominate the market thru over aggressive, bulling and, in many cases, questionable tactics. Still that doesn't make it the best.
Macho statements like "all other databases are toys" are tipically made by DBAs who are so entrenched in their position, and are terrified of loosing if Oracle is replaced with another product. The market is full of Oracle consultants and DBAs sitting on the bench, but don worry my friend, I'm sure Oracle will take care of you.