Copy Table in SQLPLUS

5 pts.
Tags:
Access
Access Database
SQL tables
SQLPlus
How to copy a table from an access database using sqlplus

Answer Wiki

Thanks. We'll let you know when a new response is added.

U may try out the below :

1. Open the SQL view window.

2. Type SELECT * and press Enter. This statement will select all the columns from the table you want to copy

3. Type INTO and the name you want to give the new table.
NOTE : For eg, INTO NewTable. This statement will make sure that the copied columns are placed into the new table.

4. Now Press Enter

5. Type FROM & the name of the table you want to copy.
NOTE: For eg., FROM anytable (Old one)

Now run the query !

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Hi "VB and Access", Rechil provided a good answer on how to copy an Access table into another Access table, is that what you need ? Since you mentioned "sqlplus", one could think that an Oracle database is involved. If the answer provided doesn't help, please provide more details.
    69,240 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following