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
ravi214u
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member
hi,

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
Littlefoot
Messages: 21040
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: Sun Mar 26 15:53:00 CDT 2017

Total time taken to generate the page: 0.09691 seconds