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: 20891
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: Sat Dec 03 20:16:25 CST 2016

Total time taken to generate the page: 0.09525 seconds