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: 20847
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 Oct 26 01:32:49 CDT 2016

Total time taken to generate the page: 0.05132 seconds