Home » SQL & PL/SQL » SQL & PL/SQL » Copy Table Structure and Data (oracle 10g,Pl/sql developer)
Copy Table Structure and Data [message #309536] Thu, 27 March 2008 16:12 Go to next message
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member

Is there a way to copy the structure of table and data in a single file.

thanks in advance
Re: Copy Table Structure and Data [message #309539 is a reply to message #309536] Thu, 27 March 2008 16:44 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export/import utilities might help.

P.S. Or, CTAS (Create Table As Select) would do the job as well (without constraints (different from NOT NULL), indexes or triggers).

Of course, if that's what you are looking for (as I didn't understand what a "single file" means).

[Updated on: Thu, 27 March 2008 16:46]

Report message to a moderator

Previous Topic: Is it possible in SQL or PL/SQL pls advise
Next Topic: date query
Goto Forum:

Current Time: Wed Aug 16 08:18:43 CDT 2017

Total time taken to generate the page: 0.13417 seconds