| oracle tables [message #21538] |
Sat, 10 August 2002 22:46  |
Renu
Messages: 7
Registered: February 2002
|
Junior Member |
|
|
Sir,
how can i copy oracle tables (structure+data) into floppy to use it into other pc. Can we make sql scripts for tables so that by using that script it will automatically create and insert record into it by running query. How can we create a script of already created table.
|
|
|
|
| Re: oracle tables [message #21539 is a reply to message #21538] |
Sun, 11 August 2002 05:08  |
Mark the Shark
Messages: 15
Registered: February 2002
|
Junior Member |
|
|
Oracle db is a client server product, so coping the structure and data to a floppy is not possible.
You can create tabels in a script and run them in sql+
CREATE TABLE your_table
(id NUMBER(6) primaryu key,
next_field VARCHAR2(15),
next_field VARCHAR2(15);
table.sql
run in sql+
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
